Parameter Query Question

[Christina]

Hi. I am trying to run a parameter query based on the
date field where the date field in the table is set to
default to today's date. The query doesn't return any
records. Any one know how I can do this? Thanks.

 

[[MVP] S. Clark]

A default in a table only works when NEW records are added. Have you added
any new records to the table since the default was set?

Feel free to post your SQL statement.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Christina]

I have added new records since the default was set. These
are the records that don't show up when I run my query.
Thanks.

 

[John Spencer (MVP)]

Is the default Date() or is it Now(). If you have used Now() then you are
storing the date and time in the field.

As a test, try the following criteria in your query.

WHERE TheDateField >= Date() and TheDateField < Date() + 1

If that returns the expected records, then you are probably storing the Date and
Time in your field.