B
Box666
I have a form open and I want to use the date from it in an expression
on a report that will open shortly - the form will still be open.(where
the form is called "RepInfo" and the date is "Lstupdt" in the format of
dd/mm/yyyy)
In plain english I want to say if the form date is the same month as
todays date then show message 1, if not show message 2. I have tried
various option but I cannot seem to hit the right combination.(I seem
to be having problems with my "," and ")" - amongst other things)
Assistance greatly received..
=Iif
(dateserial(Year([forms]![RepInfo]![Lstupdt]),month([forms]![RepInfo]![Lstupdt])=dateserial(Year(date()),month(date()),"Reports
Last Updated "&[forms]![RepInfo]![Lstupdt],"CARE Reports NOT yet
updated this month")
on a report that will open shortly - the form will still be open.(where
the form is called "RepInfo" and the date is "Lstupdt" in the format of
dd/mm/yyyy)
In plain english I want to say if the form date is the same month as
todays date then show message 1, if not show message 2. I have tried
various option but I cannot seem to hit the right combination.(I seem
to be having problems with my "," and ")" - amongst other things)
Assistance greatly received..
=Iif
(dateserial(Year([forms]![RepInfo]![Lstupdt]),month([forms]![RepInfo]![Lstupdt])=dateserial(Year(date()),month(date()),"Reports
Last Updated "&[forms]![RepInfo]![Lstupdt],"CARE Reports NOT yet
updated this month")