Access Reports

DEVELOPERMARK.COM

Access Reports

1
2
3
4
5
6
7
»
»»

Source Object in subreport

is it possible to change the subreports' source object depending on certaincriteria? I have 32 subreports and instead of making 32 main report I onlywant to have 1 main report. This would make future re-formating of the mainreport easier.THANKS!...

4 answers | 273 bytes |

Sorting/Ranking Aggregate Expression in Control Source??

I would like to sort the results of the following expression in controlsources located in the detail footer in order to rank the results.=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])Is it possible?Thanks for your help.BevC....

4 answers | 329 bytes |

sorting/ordering

i am working with a new database in which apartment information is kept.there are forms and subforms all over the place. when i produce reports,there is one hall that does not produce the suites in chronological order.the problem is that i cannot locate where to correct the sort order for thissp...

1 answers | 366 bytes |

Sorting/Multiply Sorting

Hi,I am using Access 2002 and I hoping someone can help me or point me to awebsite for more information. Here is the scoop. I work for a reinsurancecompany and I have a particular report that the users like, but they wantthe option to have the report sorted their way. For example one user wantst...

1 answers | 889 bytes |

Sorting/Grouping Report

Hello,Is there any way for me to sort a report by a calculated field that is onthe report footer?Thanks,D_K...

5 answers | 139 bytes |

Sorting/Grouping

Hello,I have a problem with Acc2003, it worked fine with acc97.1) I have a report with Sorting/grouping section and I want that every groupshould start a new page. I set the Force New Page to Before Section. Nowwith acc2003 the first page is blank.(the After Section with the Keep Together doesn&...

1 answers | 378 bytes |

SORTING/GROUPING

Anyone familiar with syntax for an Expression in theReport Sorting and Grouping Field/Expression window?Trying to use a one character field to create 3 groupsdepending on value stored in the field.Example:Field is called RECORD-TYPEField can have 1 of 3 values (C, L, or M)So would like to form a...

1 answers | 592 bytes |

Sorting/Grouping

HiI have a list in my table which, when displayed in areport I would like them in a specific order. The sortfield displays two digits of data, the first character isa letter representing the month:-Jan = FFeb = GMarch = HAr = JMay = KJune = M etc....The second character is a number representing...

3 answers | 842 bytes |

Sorting without grouping

I have a report which shows detail of invoices to customers which fall into 2categories �C new work and monthly support payments. I want the report to sortand group as follows:Group 1 �C CustomerGroup 2 �C Type of Sale (Category)Group 3 �C Invoice DateGroup 4 �C Monthly RateThe problem I have is that...

8 answers | 846 bytes |

sorting within an interval

I have a series room numbers which are geographically sorted so that rooms1-10 are in one block, 11-20 in another block etc. Sometimes there are tenrooms in a block, sometimes just 2 or 3.I have a report that has a grouping interval 10 and a small footer so thateach time the room numbers move to...

1 answers | 1020 bytes |

Sorting with sub reports

I am trying to create a report with following structure.The parent report is drives three sub reports. The parent is group byorganization. Each organization may send out 1 or more solicitations forcontract work (first sub report is solicitations). Each solicitation mayresult in one or more contr...

0 answers | 1022 bytes |

Sorting with conditions? Help!

I have a report that gets printed with partially completed sales orders andis filtered to sales orders for OrderDate field.I have tblOrders and tblOrderDetails. A tblCustomer andtblCustomerDestination are related to tblOrders with one to manyrelationships. tblCustomer is independent of tblCustom...

5 answers | 1056 bytes |