lvjan777
Last Activity: Nov 6 '07, 10:15 PM
Joined: Nov 7 '06
Location:
-
I hard coded the dates in the query and it works fine with # around the date. I'm passing in the dates from a form with two unbound text boxes. I was testing the query in the QBE and didn't get the results I expected. When I pass in the dates from the form, it works. Thanks for your help.... -
Thanks for your help. I'm still having problems with this though. It works for some dates, but not others. Here is the sql. I don't know where to delimit the dates with pound signs. I tried cdate on the date coming from the form but that didn't help.
My first record has a start date of 4/12/04 and an end date of 8/30/07. I input 4/1/04 and 4/30/04 as the date ranges, but it doesn't return the first record. Both criteria are...Leave a comment:
-
Date Criteria that falls within a date range
Access 2003 Windows XP Professional
I'm trying to open a report that displays all the records that are active during the user selected start and stop dates. I’m having trouble with the syntax since there are two input dates and two database dates to compare.
If they select 1 Apr 04 – 30 Apr 04 I want to see record 1.
If they select 1 May 04 – 30 May 04 I want to see record 1 and 2
Record... -
Can anyone tell me how to execute an access database from a vb program? Our windows scheduler is disabled. The database resides on my local machine.Leave a comment:
No activity results to display
Leave a comment: