View Single Post
  #1  
Old May 21st, 2010, 05:00 PM posted to microsoft.public.access.queries
JK[_4_]
external usenet poster
 
Posts: 51
Default Total - Total Fields in a Totals Query

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