By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Report sorting and order of fields problems

P: n/a
Hello
I am using the report wizard in A2K to print 4 fields with my table as
my data source. I would like the order of the fields to stay the same
a; b; c; and d. When I make "print 1" and sort on "a" the order is
correct but when I make a report "print 2" where I want to sort on "b"
then the order becomes b; a; c; d.
Is there any way to avoid this? If I were to make queries would I
have the control I am looking for?
Thanks
Ralph
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In design view of the Report, in the upper leftmost corner, click the little
box, then right-click, and choose Sorting and Grouping -- the order of the
RecordSource of the Report does not determine the order in which the Records
appear.

Larry Linson
Microsoft Access MVP

"Ralph" <un*****@yahoo.com> wrote in message
news:c9********************************@4ax.com...
Hello
I am using the report wizard in A2K to print 4 fields with my table as
my data source. I would like the order of the fields to stay the same
a; b; c; and d. When I make "print 1" and sort on "a" the order is
correct but when I make a report "print 2" where I want to sort on "b"
then the order becomes b; a; c; d.
Is there any way to avoid this? If I were to make queries would I
have the control I am looking for?
Thanks
Ralph

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.