subquery expression HELP!

[BFish]

Any help will be appreciated.

I'm trying to get MTD invoice totals for different categories of invoices.
I'm very much having a problem incorpating the CodingID (CodingID = the 4
categories numeriacly) for the table into this statement for filtering.

MTD Gross Prft %: ((DSum("InvoiceSale","tblInvoices","DatePart('m', [Date])="
& [AMonth] & " And DatePart('yyyy',[Date])<=" & [AYear] & ""))-(DSum
("InvoiceCost","tblInvoices","DatePart('m', [Date])=" & [AMonth] & " And
DatePart('yyyy',[Date])<=" & [AYear] & "")))/(DSum("InvoiceSale",
"tblInvoices","DatePart('m', [Date])=" & [AMonth] & " And DatePart('yyyy',
[Date])<=" & [AYear] & ""))

As can be seen I'm getting a total of all invoices in gross profit format for
the date requirement filter. I believe a And function is needed, but have
limited experience with expressions. I did try to create a new field with
the CodingID and where clause, but of course to no avail.

Any help would be great and thanks in advance.

Bill

 

[[MVP] S.Clark]

I like to do seperate queries for things, then link them together into
another query. This allows for simplified debugging and maintenance. What
you have there is almost impossible to read, understand, and specify what to
change.