set date in access report

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting date value in Access Report 1
Counting in Report 3
Access Access, problem with query. 5
Open filtered report 8
Access 2000 - Extracting DAY filed From Date 2
Extracting * Sorting DAY of Date 1
Access Access 2007 Report Question 8
Count Function (conditional counts) in Reports 3

Top