Please Help - I'm Stuck !!!!

[Ishiguru]

Hello, I wonder if anyone can help me.

I currently have a Database which is used to track Jobs.

I am having problems with sorting on one of the reports.

The report is summarised into area with a count for the number of jobs against each area i.e.

Leeds = 10 Jobs
London = 24 Jobs
Edinburgh = 7 Jobs
Glasgow = 3 Jobs etc

However I would like the above data sorted by the number of jobs in descending order.

So it would appear

London = 24 Jobs
Leeds = 10 Jobs
Edinburgh = 7 Jobs
Glasgow = 3 Jobs

It's probably a really easy solution, but I just don't know how to do it.

Thanks in advance for any help you can offer.

 

[simongallop]

What is feeding the information to the report. Do you have a field that has the numbers by themselves? If so then right click on the top left hand corner of he report in design view and click on Sorting & Grouping and sort by that field.

 

[Ishiguru]

Hi Harry,

Sorry I should have been more clear.

The field which shows the number of jobs is just a text box with the following count function in it

=Count(*) & " " & IIf(Count(*)=1,"Job","Jobs")

So I have on my report :

Page Header - which contains Title of report, field headings etc.
Area Footer - which contains Area, and the above count in a text field.

 

[KKilfoil]

Ishiguru:

I would create a summary query using the report's data source to calculate total jobs, making sure the FK to cities is included as a 'group by'.

and then create a second query contining original source and the new query. Relate the two by the FK, and you can use the total_jobs field in your report, including in the sort criteria.