Results 1 to 6 of 6
  1. #1
    everette is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    17

    Between [Enter Start Date] And [Enter End Date] is not working

    I've got a linked table I need to pull records for a report. I have used the following Between [Enter Start Date] And [Enter End Date] in the criteria under the date of the linked table. It pulls almost all the records instead of pulling just the records between the dates. Thanks in advance for any help.
    Everette

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Could this be your issue? http://allenbrowne.com/ser-36.html

  3. #3
    everette is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    17
    I don't think any of those are the issues. I've used this on several databases and have not had any problems. Could it be because it is a linked table?. I checked the table and it is set up as a date and I'm in Georgia.
    Thanks
    Everette

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Using a linked table should have no effect on the results except for maybe time if it is remote. Aren't you using a query as a RecordSource of the report?

  5. #5
    everette is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    17
    I've got both databases sitting on my desktop so its not a distance issue. I even rebuilt the query again, read somewhere about SQL getting hung up. I'm not advanced enough to understand that, but it worked the first couple of time, but then back to the same thing. I'm really at a loss.
    Thanks
    Everette

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try *importing* your db into a fresh, new db and see if the problem follows. You could be dealing with some form of corruption. http://www.btabdevelopment.com/ts/impnew

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Yes/No, If yes Enter Number
    By kennyrogersjr in forum Forms
    Replies: 1
    Last Post: 11-29-2010, 07:37 PM
  2. Enter Parameter Value
    By T001 in forum Access
    Replies: 1
    Last Post: 08-11-2010, 05:43 AM
  3. Replies: 11
    Last Post: 08-04-2010, 04:26 PM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums