If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Query Help Please
Hello and thanks in advance to anyone who can help me.
I am writing a query using Access 2000 where I need to query between two dates which are input by the user. The basics of the query is * User Input * Enter Registration Number * User Input * Enter Date To Query From * User Input * Enter Date To Query To * Query Output * Results So when the query is run is will ask for the Registration number, then the dates. I can remember doing this with Access 97, but for some reasons I think the syntax has changed from Access 2000 inwards. As I am the only person in the office who understands SQL there is no point in writing in that language and I have to make it simple for everyone else. Again, many thanks in advance for help P W S |
#2
|
|||
|
|||
SELECT *
FROM [YourTable] WHERE ([RegIDField] = [Enter Registration Number:]) AND ([DateField] BETWEEN [Enter Start Date:] AND [Enter End Date:]) When the Query is run, Access will ask for Reg No. then Start Date then End Date. -- HTH Van T. Dinh MVP (Access) "Peter W S" wrote in message ... Hello and thanks in advance to anyone who can help me. I am writing a query using Access 2000 where I need to query between two dates which are input by the user. The basics of the query is * User Input * Enter Registration Number * User Input * Enter Date To Query From * User Input * Enter Date To Query To * Query Output * Results So when the query is run is will ask for the Registration number, then the dates. I can remember doing this with Access 97, but for some reasons I think the syntax has changed from Access 2000 inwards. As I am the only person in the office who understands SQL there is no point in writing in that language and I have to make it simple for everyone else. Again, many thanks in advance for help P W S |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query week to date, month to date, year to date hours | Ty | Running & Setting Up Queries | 1 | December 15th, 2004 03:46 AM |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |