By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,148 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

Making a query from a query using calculated fields

P: 2
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?
Apr 14 '15 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,430
Please post the SQL code along with the full error message.
Apr 14 '15 #2

zmbd
Expert Mod 5K+
P: 5,397
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
Apr 15 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.