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 in a sql statement
What is the criteria to put a data in a query. I what to have the user
select the correct date. I've tried #[date]# [#date#] Please help me out. thanks |
#2
|
|||
|
|||
Not sure what you mean. To prompt for the date, you'd do...
SELECT Employees.HireDate FROM Employees WHERE (((Employees.HireDate)=[enter date])); To specify a date, you'd do... SELECT Employees.HireDate FROM Employees WHERE (((Employees.HireDate)=#12/31/1999#)); -- Rick B "Joel" wrote in message ... What is the criteria to put a data in a query. I what to have the user select the correct date. I've tried #[date]# [#date#] Please help me out. thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a sum of records in an open recordset(Access97) | Reiner Harmgardt | General Discussion | 0 | March 7th, 2005 10:03 AM |
Unable to insert record to Access via SQL from an ASP page | Norman Yuan | General Discussion | 1 | February 2nd, 2005 08:23 PM |
Calculated Mean | Charles Deng | Running & Setting Up Queries | 21 | October 15th, 2004 08:37 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |