sort on a calculated control in a report in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which sums charges for customer in the detail section which
is set to visible = no so all you see is the totals for each customer. I
would like to sort the report using the calculated field in the detail group
footer. I seem to remember this is possible but can't fond out how to do it.
Any help would be appreciated
Mike
 
Hi Mike

You would be best doing the calculation in the query.

Like this
Sorting:[TableName]![FieldABC] + [TableName]![FieldXYZ]

Then insert [Sorting] into the report (set to visible = No if you want)

Use the sorting grouping option to sort on this
 
Brilliant thanks

Wayne-I-M said:
Hi Mike

You would be best doing the calculation in the query.

Like this
Sorting:[TableName]![FieldABC] + [TableName]![FieldXYZ]

Then insert [Sorting] into the report (set to visible = No if you want)

Use the sorting grouping option to sort on this

--
Wayne
Manchester, England.



mike said:
I have a report which sums charges for customer in the detail section which
is set to visible = no so all you see is the totals for each customer. I
would like to sort the report using the calculated field in the detail group
footer. I seem to remember this is possible but can't fond out how to do it.
Any help would be appreciated
Mike
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MSACCESS - Sorting report based on field calculated in the report 0
Calculating a grand total for an unbound control in a report 9
Sorting by a calculated field 12
Wrong Sum in Report Footer 2
Enter Parameter Value - Custom Calculation In Report 2
Running sum on report 4
Want Sum in Report Header of calculated field in Report Detail ? 1
Total in report footer 1

Back
Top