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

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

qurey related 2
Calculation Error in Select Query 9
Query Help One-to-Many 4
How do I make an update query that uses multiple tables? 3
Order Query 3
query parameter ignored - please check my syntax 5
Subquery not integrating to query to display previous sum of quantities 3
Query not working for SQL Server 2

Back
Top