Making a query from a query using calculated fields

[davidjdibene77]

I have a table of invoice items. I created a query based on that table. I also created 2 calculated fields in that query: 1 to segregate the taxable items and another the non-taxable items. I then created another query based on the first query. I clicked on the "Total" (Z) icon. On the calculated fields, I changed the "group by" designation to "Sum". When I ran the query, I got an error message "3701". I don't know how to make the expressions more simple.

I am trying to create a report (invoice) with the following fields in the footer: 1. Total materials (taxable items), 2. Total Labor (non-taxable items, and 3. Grand total of all charges.

I am at a loss as to how to fix this. Can anyone help me?

[Rabbit]

Please post the SQL code along with the full error message.

[zmbd]

davidjdibene77:
Please make sure that you click on the "[CODE/]" button first and then paste your SQL between the two code tags otherwise my antivirus tends to complain about the page :)

IF you need help getting the SQL just post well guide you thru the process.
-z