Hi guys,

Im having a bit of a problem regarding the ordering in a report.

Basically I'm compiling a programme of events. Each event has a number; a category contains a number of events.

Just now my report is set up as follows:

Dance
20. Event Name
21. Event Name

Fiddle
10. Event Name
11. Event Name

etc etc.

This is great, but the forst order by goes with the Category Name (alphabetically). I dont know if this is possible, but I want it to go on the order of the event number. The idea being that the report will contain events from 1 to 300 or whatever it is, in order. For Example:

Fiddle
10. Event Name
11. Event Name

Dance
20. Event Name
21. Event Name

Piano
200. Event Name
201. Event Name

All of the event numbers are together (like, piano events are 200 - 210, Fiddle is 10 - 19 etc). When i tried putting event number as the top order by, it shows the category name above each event rather than grouping~

Any help would be amazing!!!

did u try the grouping and sorting option in the report options?

Well yeh, its currently:

Category - Group Header Yes
Class No.

SO it has the category, and each event in that category below. And the events are ordered within the class by the class number. This is all good - but looking at the overall report, I want the categories to be ordered by the numbers of the event rather than by the category name!

SO, even though a category may be called ZZZ Category, it might appear first in the report because its events are numbers 1 - 10!

sounds like u need to base your report off of a query instead of just using the sorting by category... that will be later on.

i think i know what u are thinking about. can u post a sample?

No probs - ive attached an extract from the report (Afte being exported to word). That is how it is now. But if it was setup the way I want it, the categories would be the other way around!

i meant a sample db so i can look at your table structure for writing a query

sorry about that

Ah sorry! MM, trouble is that my DB is about 20 mb, and contains personal info on a good 1000 people...mm, i can try making a copy of the DB and taking out some info etc..

yes definately dont post personal infomation!!

after you create a copy >compact and repair then zip to post

there she is - basically ive deleted all data/forms/queries/reports/ apart from the ones required for what we are looking at..

Thanks again for taking a look!

no matter what i tried i couldnt get it to do what u wanted.... sorry. im sure it CAN be done. just not by me. perhaps someone else will take a look at it. you are on the right track as far as i can tell though.

ah ok! no worries - thanks a lot for tryin!! I shall keep trying..