Calculating values 1

[leewisener]

Hi,

I have a query setup using the design grid in access, not comfortable with the sql view yet.

Basically I have 5 fields in there with the totals bar displayed, each field looks something like:

Field: Promises
Table: Payments
Total: sum
Sort: descending

I want to enter something like the following in a blank field

Collected%: ([Actual pymt]/[paymt])*100

I entered this in a blank field and put the text above in to calculate the % paid against due.

The problem is that it wont display, the error message sugggests I duplicate the field and it will display. But that does not work.

Any Ideas?

Thanks

Lee

 

[PHV]

Collected%: 100*Sum([Actual pymt])/Sum([paymt])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[leewisener]

Worked perfectly, thank you.