"Between date" query

  • Thread starter Thread starter C_F
  • Start date Start date
C

C_F

I have a query that I use to return transactions that happened between a
specific set of dates, and the person responsible for those transactions. It
worked fine for a few months, but now returns odd results. For example, if I
select a date range of 09/01/05 to 09/30/05, it also returns records from
03/05, 05/05, 06/05, and 10/05. I've gone through post after post with no
answer. Can someone point me in the right direction?
 
The dates you have provided are between the dates you are querying?

John
 
Hi,


Do you use a date_time field or a string, as data type, to hold the date
data?

Are the date all in US format, dd-mm-yyyy, or are some also in the format
mm-dd-yyy, or worse, are there some with only two "numbers", like dd-mm
( or mm-dd) ? Is that a possible pattern for the records "in error" ?


Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

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

Limiting multiple results in query 7
Difference in Date/Time 1
Query between dates - help needed 7
Access Running Balance in Access 1
DATES - Grouping sets of sequential dates 3
Totals Query 2
Looking up across date ranges in Access 2
Advanced problem using auto-number and datediff to find readmissio 1

Back
Top