S
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!
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!