Creating a report

  • Thread starter Thread starter Christina G.
  • Start date Start date
C

Christina G.

Using a date of birth feild. How can I creat a report by people who were 5
by 12/2/10? The access program I use is 2003
 
Well to be five or over on 12/2/10 there dob would have to be equal to or
greater than that date 5 years ago.

So use criteria to filter the data
<= DateAdd("yyyy",-5,#12/2/10#)

Your date is ambiguous. Is it supposed to be December 2, 2010 or February
12, 2010? If you are using a date literal such as 12/2/10 then you must
express that date in the form month day year or year month day (yyyy-mm-dd).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

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

Sorting within a Report 1
Summary Report 2
Counting in Report 3
How to create a report in Access that would use a date range 8
Union Report 4
How do I create a report based off of several Combo Box selections 4
Calculate age between two dates 3
dlookup in texbox in report 1

Back
Top