If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|