Report Format

  • Thread starter Thread starter Mikey
  • Start date Start date
M

Mikey

Hi -

I would appreciate some help on the following problem I
have with my report format.

Basically, I wrote an SQL query that 'pulls' data from 2
separate tables and stores them in a temporary table
(i.e. a "SELECT, FROM, INTO..." statement).
In my SQL statement, I stated that the data for Field A
should be sorted in ascending order.
My problem is, when I the SQL query looks right when I
open the temporary table. However, when I run the report,
field A is messed up and not sorted!

Please tell me what I am missing!

Thanks
 
Hi -

I would appreciate some help on the following problem I
have with my report format.

Basically, I wrote an SQL query that 'pulls' data from 2
separate tables and stores them in a temporary table
(i.e. a "SELECT, FROM, INTO..." statement).
In my SQL statement, I stated that the data for Field A
should be sorted in ascending order.
My problem is, when I the SQL query looks right when I
open the temporary table. However, when I run the report,
field A is messed up and not sorted!

Please tell me what I am missing!

Thanks
Click to expand...

Any sort order in a table or query is irrelevant to the sort order in
a report.
Sort the report using the report's Sorting and Grouping dialog.
In Design View, click
View + Sorting and Grouping
 
Don't rely on the "perceived" order of records in a datasheet view to be
carried over to the report. Use the report's sorting and grouping dialog to
display your records in a particular order.
 
Thanks Fredg!
-----Original Message-----


Any sort order in a table or query is irrelevant to the sort order in
a report.
Sort the report using the report's Sorting and Grouping dialog.
In Design View, click
View + Sorting and Grouping
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top