Two questions regarding manual input to calculated fields/reports

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

Haven't used Access since 2000, and now trying 2007.
The first question should be relatively easy, but can't get it to work.
Working with four fields, the first three manually input. (1) "End Date" in
month/day/year format, (2) "Follow Up Required" in Y/N format, (3) "Follow
Up Freq" # of years in numeric/no decimals format and (4) "Follow Up Date"
which will be calculated. Shouldn't the formula be [iif("Follow Up
Required"="Yes","End Date" + "Follow Up Freq" * 365,"")? Where should this
formula be entered.
Second questions concerns reports. The Query searches 10 fields for the
individual's name and the generates list [criteria is "Name"=? in the 10
fields using "or"]. The report/query works fine, but I would like the
parameter (manually input to request the specific report) to show on the
report. How can that be done?
Thanks for your help!
 
Shouldn't the formula be [iif("Follow Up Required"="Yes","End Date" +
"Follow Up Freq" * 365,"")? Where should this formula be entered.
No. Your 'Follow Up Freq' is in years so you add years.
IIF([Follow Up Required] = Yes, DateAdd("yyyy", [Follow Up Freq], [End
Date]), Null)
OR if you want a date when 'Follow Up Required' is no then use this the
have follow-up date the same as 'End Date'.
IIF([Follow Up Required] = Yes, DateAdd("yyyy", [Follow Up Freq], [End
Date]), [End Date])
Bad table structure having name in one of 10 fields. There should be "A"
field for name with a record for each separate name.

Doug said:
Haven't used Access since 2000, and now trying 2007.
The first question should be relatively easy, but can't get it to work.
Working with four fields, the first three manually input. (1) "End Date" in
month/day/year format, (2) "Follow Up Required" in Y/N format, (3) "Follow
Up Freq" # of years in numeric/no decimals format and (4) "Follow Up Date"
which will be calculated. Shouldn't the formula be [iif("Follow Up
Required"="Yes","End Date" + "Follow Up Freq" * 365,"")? Where should this
formula be entered.
Second questions concerns reports. The Query searches 10 fields for the
individual's name and the generates list [criteria is "Name"=? in the 10
fields using "or"]. The report/query works fine, but I would like the
parameter (manually input to request the specific report) to show on the
report. How can that be done?
Thanks for your help!
Click to expand...
 
Back
Top