Report Grouping without Sorting?

[servantofone]

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!

[PianoMan64]

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!

Hello,

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

TableName: ORDER
--------------------------------------------------------------------------
FieldName                  Field Type                 Comments
--------------------------------------------------------------------------
ID                         AutoNumber                 Primary Key Value
Order_ID                   Long Interger              The you want this record to appear in.
Description                Text(50)                   Description or Name of Item
--------------------------------------------------------------------------
You would enter the information as follows:
Order_ID   Descritpion
----------------------
1          Cherry
2          Apple
3          Grape

Then you would simply sort by Order_ID

Hope that helps,

Joe P.