If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a report
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 |
#2
|
|||
|
|||
Creating a report
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 Christina G. wrote: 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 |
Thread Tools | |
Display Modes | |
|
|