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
|
|||
|
|||
"Between date" query
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? |
#2
|
|||
|
|||
"Between date" query
The dates you have provided are between the dates you are querying?
John "C_F" u16690@uwe wrote in message news:58e0073638d66@uwe... 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? |
#3
|
|||
|
|||
"Between date" query
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 "C_F" u16690@uwe wrote in message news:58e0073638d66@uwe... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |