Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Hartford, CT

    Unanswered: Access Date issue


    We have been having this problem for long time. We run this query to generate a report based on a date that the user enters through prompt. The query never works correctly the last day of each month. It returns a subset of the expected data and some of the data is corrupted. But it works great the rest of the months. A copy of the query in the design view, a sample data, and the error messages are attached. Please Help.

    Thanks a lot.
    Attached Files Attached Files
    Last edited by mkasem; 04-01-03 at 17:07.

  2. #2
    Join Date
    Sep 2002
    South Wales

    More details please

    Where are [startdate] and [enddate] coming from?

    Are they just input by the user when the query runs?

    Also are you sure that the query should gather data BETWEEN [startdate] and [enddate]? Perhaps should be

    >= [Startdate] and <= [enddate]

    ?Not enough detail given for me to diagnose though - If the above does not help post email me directly
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts