HELP W/ DATES

[Joe Hennessey]

Ok what im trying to do is i have a database with all
accounts in it. What i want to do is run a query to pull
out all the acounts that have the years 98, 99, and 00 in
the date field so i can close them out. How do i search
for just the last 2 digits in the date so i can pull out
all 98, 99, and 00 accounts? Please somebody help me.

Thanks, joe

 

[Van T. Dinh]

Try the Query with SQL String like:

SELECT *
FROM YourTable
WHERE DateField BETWEEN #01/01/1998# AND #12/31/2000#

 

[John I]

Joe,
another way is to write a new qry using the tabel that has
the dates. In design view go to the column that has the
date field in it. Use the following as the criteria:
<=01/01/1998 and >=12/31/2000

if you date field only has 2 digits then use the 2 digit
year instead... this is only if you like to work wiht the
design view instead of writing the sql.

JI