J
jenniebentham
Having read millions of time not to store results of calculated fields in
tables, I have the following in a field on a form that calculates a date 6
months in the future [target date] from an field [actual date]
=IIf([Actual Date] Is Not Null,DateSerial(Year([Actual Date]),Month([Actual
Date])+6,Day([Actual Date])))
However, I now need to produce a query and report on [target date] and I am
unsure how to put this formula into the query. I need to produce a query that
shows me all [target dates] within a given date range.
I can read some SQL, but usually use the Access query design view.
Thanks in advance!
tables, I have the following in a field on a form that calculates a date 6
months in the future [target date] from an field [actual date]
=IIf([Actual Date] Is Not Null,DateSerial(Year([Actual Date]),Month([Actual
Date])+6,Day([Actual Date])))
However, I now need to produce a query and report on [target date] and I am
unsure how to put this formula into the query. I need to produce a query that
shows me all [target dates] within a given date range.
I can read some SQL, but usually use the Access query design view.
Thanks in advance!