I appreciate all the help but I am putting this aside for now.
Thanks - AnderJ86
AnderJ86
Last Activity: Jul 9 '09, 01:20 PM
Joined: Jul 6 '09
Location:
-
The error this time said "you tried to execute a query that does not include the specified expresion ExpirationDate: IIf([expire-dt]>#08/31/2009#,DateSeria l([xyear], 8, 31),#08/31/2009#) as part of the aggreget function."
I also tried changing the way [xyear] was created first I used Year[expire-dt]-365 then I changed it to xyear: DatePart("yyyy" ,[expire-dt]-365) both returned the correct yyyy but I don't know...Leave a comment:
-
Thanks ChipR I tried:
ExpirationDate: IIf([expire-dt]>#08/31/2009#,"8/31/" & [xyear],"8/31/2009")
It errored with " The expression you entered contains invalid syntax)
It is all on one line. The two ExpirationDate' s was a typo. If the syntax is correct I will just keep tweeking it until it works. - ThanksLeave a comment:
-
Thanks ChipR I tried:
ExpirationDate: ExpirationDate: IIf([expire-dt]>#08/31/2009#,"8/31/" & [xyear],"8/31/2009")
It errored with " The expression you entered contains invalid syntax)Leave a comment:
-
iif Concatenation of set day/month with year from another field
In an access query I am trying to concatenate the year from one field onto a set day/month.
Here is where I'm at:
ExpirationDate: IIf([expire-dt]>#08/31/2009#,("8/31/" & [xyear]),8/31/2009)
The ("8/31/" & [xyear]) part should result like 8/31/2014 as an example. [xyear] is a four digit year.
I'll apreciate any help.
Thanks - AnderJ86
...
No activity results to display
Leave a comment: