set date in access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

trying to set date field....

have a date of birth field, need to set second field on report to be date of
birth +5844 (16th birthday) or Date()-187 (six nonths), which ever is the
greater....

this is to set a registration date that can be backdate from now by six
months but not before the candidate's 16th birthday...

Help please..!
 
Graham

One approach would be to use a query to get DOB and to do the calculations
you are describing. Then you'd use that query as your source for the
report.

--
Good luck

Jeff Boyce
<Access MVP>

"Graham (The Jock) Thomson."
 
Back
Top