Ordering categories in a report. 1

[rcoutts]

I have a (3) column table that I'm using for my report:

   Category   Description                   Subtotal
   --------   -----------------------       --------
   Balance    Previous Balance                  $100
   Balance    Amount Received                     50
   Fees       1000 Fee X 50% complete         
   Fees       less $100 Previously billed        400
   Costs      Supplies                            10
    ...          ...                            ...

I am using the Report Wizard to create a Report that groups by the 1st Column ("Category&quot, So my report looks like this:

   Balance
               Previous Balance                  $100
               Amount Received                     50
   Costs
               Supplies                            10
   Fees
               $1000 Fee X 50% Complete
               less $100 Previously Billed        400
     ...             ...                          ...

Which is _almost_ what I want. The Report is grouping things correctly, but then it goes ahead and sorts them alphabetically. I really want them sorted on a 1st come, 1st served kinda way (e.g., its important that "Fees" comes before "Costs&quot. Is there a way to do this? If I can't shut off alphabetizing, is there an alternative to get the result I'm after.

Thanks!
Rich

 

[donnadee]

Can you assign a date to the first come first served item?

You can hide the date from showing on the report.