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

Sorting Results in a Report based on a selection

P: 34
Hi, i have literally been racking my brain about this one and i think i need some help.

I have a report which is produced when a button on a form is pressed. The report has many fields and records and i want the user to decide how to sort the report.
I have started with a combo box which has a few values in it, all spelt the same as the field headings in the query (where the report is generated from). I have tried adding the code:

Expand|Select|Wrap|Line Numbers
  1.  [Forms]![frm FVQ main]![cboSortBy] 
and even
Expand|Select|Wrap|Line Numbers
  1.  =[Forms]![frm FVQ main]![cboSortBy] 
and also (maybe out of desparation),
Expand|Select|Wrap|Line Numbers
  1.  =[[Forms]![frm FVQ main]![cboSortBy]] 
into the 'Order By' field on the properties of the report but to no avail, then i tried with the same code in the 'Sorting and Grouping' box but again, no sorting.
Im sure there is something simple that im missing, is there anyone who can suggest something??

I am using Access '97.
Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hi Jon,

See if these links help:

This link shows you step by step how :

http://www.fabalou.com/Access/Reports/sortorder.asp


See also:
http://www.thescripts.com/forum/thread659192.html
Jun 10 '07 #2

P: 34
Hi Jon,

See if these links help:

This link shows you step by step how :

http://www.fabalou.com/Access/Reports/sortorder.asp


See also:
http://www.thescripts.com/forum/thread659192.html

Cheers, the 'fabalou' explanation worked. (not that im saying the scripts suggestion wasnt also good mind !!)
Jun 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.