Total - Total Fields in a Totals Query
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).
--
Daryl S
"JK" wrote:
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
|