MS Access 2000 query related

  • Thread starter Thread starter vg
  • Start date Start date
V

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
 
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
'====================================================
 
Back
Top