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

Report Grouping without Sorting?

P: 33
I'm running Access 2003 on XP.

I have a report that needs to be grouped by a field that contains values such as:

Cherry
Apple
Grape

I need to group my report by this field, but I am required to conform to the above order. If I group this field, it is forcing me to sort ascending or descending, both of which destroy the required order.

Is it possible to group in a report without sorting?

Thanks!
Nov 26 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
@servantofone
Hello,

Well, What I would suggest is to create a table named Order with the following information:

Expand|Select|Wrap|Line Numbers
  1. TableName: ORDER
  2. --------------------------------------------------------------------------
  3. FieldName                  Field Type                 Comments
  4. --------------------------------------------------------------------------
  5. ID                         AutoNumber                 Primary Key Value
  6. Order_ID                   Long Interger              The you want this record to appear in.
  7. Description                Text(50)                   Description or Name of Item
  8. --------------------------------------------------------------------------
  9. You would enter the information as follows:
  10. Order_ID   Descritpion
  11. ----------------------
  12. 1          Cherry
  13. 2          Apple
  14. 3          Grape
  15.  
Then you would simply sort by Order_ID

Hope that helps,

Joe P.
Nov 26 '08 #2

Post your reply

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