sort on a calculated control in a report in Access 2000

M

mike

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
 
W

Wayne-I-M

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
 
M

mike

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...
 

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

Calculating a grand total for an unbound control in a report 9
(headers & footers Issue) I have 2 even pages back to back!! 1
Sorting by a calculated field 12
Total in report footer 1
Enter Parameter Value - Custom Calculation In Report 2
Want Sum in Report Header of calculated field in Report Detail ? 1
Running sum on report 4
Wrong Sum in Report Footer 2

Top