Total - Total Fields in a Totals Query

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

Any idea why this won't work?
TotalDays : nz([Sum Of VACADAYS])+nz([Sum Of SICKDAYS])+nz([Sum Of
OUTNOPAY])+nz([Sum Of HOLIDAYS])+nz([Sum Of BEREAVEMENT])

I get an error that say:
SubQueries cannot be used in the expression.

Any help would be appreciated!

JK
 
JK -

Are the field names correct? For example, is [Sum Of VACADAYS] a field
name in the source table or query? If you are basing this query on a query
that sums the records, Access usually names the fields [SumOfVACADAYS].

If this doesn't help, post your SQL (go to SQL View and copy/paste the code
into your next posting).
 
Back
Top