Thread: Access Date issue
04-01-03, 15:34 #1Registered User
- 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.
Last edited by mkasem; 04-01-03 at 16:07.Mo
04-04-03, 08:25 #2Registered User
- 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 directlyWindows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull