DAO SELECT Query

[stelios]

Hi,

I use the following statements in a DAO SELECT Query. When I run the code in
my PC I get the right results and no errors.
When I run them in another PC with the same Access version, the same Jet and
SP and the same Windows I get an error 3045 that the following statements
have error. Any Idea?

i).
IIf([User].[DateOut]-[User].[DateIn]=0,1,[User].[DateOut]-[User].[DateIn])
AS [Adm]

ii). ROUND((Date()-[User].[BirthDate])/365) AS [Age]


Thanks!

 

[Allen Browne]

The PC where this fails has a problem with its references.

Details:
http://allenbrowne.com/ser-38.html