MS Access 2000 query related

[vg]

have defined a query for obtaining "Final Bill Accounted" like this:
Final Bill Accounted: CCur(([Party Payments].[Final Bill Value])-([Party
Payments].[Audit Deductions])-([Party Payments].[Other Misc Deductions]))

But this is not working. I want to deduct 'Audit Deductions & Other Misc
Deductions' from "Final Bill Value" to obtain "Final Bill Accounted".

All the three are defined in Table called "Party Payments". Pls. help me in
this.
Reply

 

[John Spencer]

Responded to your earlier post. Please be patient. This group is
supported by volunteer efforts. Most of us have day jobs and other lives.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================