Prev: Crosstab queries, <> and null values
Next: Export to Text Files Based on Field Value
From: JK jasonk at necoffeeco dot on 21 May 2010 12:00
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
From: Daryl S on 21 May 2010 12:12
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
 | 
Pages: 1
Prev: Crosstab queries, <> and null values
Next: Export to Text Files Based on Field Value