set date in access report

  • Thread starter Graham (The Jock) Thomson.
  • Start date
G

Graham (The Jock) Thomson.

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..!
 
J

Jeff Boyce

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."
 
Top