View Single Post
  #2 (permalink)  
Old August 10th, 2006, 12:34 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Please post some data from the date fields. Access can get freaky when the dates take formats like YYYY-MM-DD, etc. SO if you date fields are not what Access is expecting, it won't return any records, or the wrong records.

One solution I use is to use a combo box to look up the dates as they are formatted, and then use them as strings to get the data filtered.

HTH

mmcdonal
Reply With Quote