Parameter Dates in Queries - not calculating correctly

G

Guest

I have set up a query to determine deadline dates based on a start date. The
deadline dates range from 1/1/07 to 3/31/08. I have set up a query to pull
the items that have a deadline that falls from the parameters that I enter.
When I enter the dates 2/1/07 to 2/28/07, it pulls those deadlines in
addition to 2/1/08 and 2/28/08 deadlines. Is this a formatting issue? What
can I do to correct this so it only pulls 2007?

Thanks in advanced for your help.
 
G

Guest

I appears that either your date field isn't a date field or you are
converting your date field to a text value. Can you discribe your table
structure and provide your SQL view?
 

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

Top