If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Translating Query formatting
I have a query that is set up to display records ordered by plan date then by
start date. When I use the query in a report, it doesn't appear to sort the records. Is there a way to make the report format the results the same as the query? Thanks, Dragon |
#2
|
|||
|
|||
Translating Query formatting
Reports should always be sorted using the Sorting and Grouping dialog in
Report Design. The order in the query often has no effect on the order in the report. -- Duane Hookom Microsoft Access MVP "Dragon" wrote: I have a query that is set up to display records ordered by plan date then by start date. When I use the query in a report, it doesn't appear to sort the records. Is there a way to make the report format the results the same as the query? Thanks, Dragon |
#3
|
|||
|
|||
Translating Query formatting
Found it! Thanks!
Dragon "Duane Hookom" wrote: Reports should always be sorted using the Sorting and Grouping dialog in Report Design. The order in the query often has no effect on the order in the report. -- Duane Hookom Microsoft Access MVP "Dragon" wrote: I have a query that is set up to display records ordered by plan date then by start date. When I use the query in a report, it doesn't appear to sort the records. Is there a way to make the report format the results the same as the query? Thanks, Dragon |
Thread Tools | |
Display Modes | |
|
|