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
|
|||
|
|||
REQ: Need Criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 Please...TIA
I have a query that that prints a bunch of payment records. I need to
beable to print just the records with in a specific time frame. I can do it if I hard code the date range into the query, but I want it to ask me for the start date and end date, so I need a criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 please. Thanks for helping in advance. Ralph Malph |
#2
|
|||
|
|||
Simply put [From] and [To] (complete with the square brackets) as the
criteria for your query. Note that if your date field has times associated with it (such as it will if you used the Now() function to populate the field, rather than the Date() function), you'll probably want DateAdd("d", 1, [To]) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Ralph Malph" wrote in message ... I have a query that that prints a bunch of payment records. I need to beable to print just the records with in a specific time frame. I can do it if I hard code the date range into the query, but I want it to ask me for the start date and end date, so I need a criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 please. Thanks for helping in advance. Ralph Malph |
#3
|
|||
|
|||
On Sat, 16 Apr 2005 17:49:46 -0400, "Douglas J. Steele"
wrote: Simply put [From] and [To] (complete with the square brackets) as the criteria for your query. Note that if your date field has times associated with it (such as it will if you used the Now() function to populate the field, rather than the Date() function), you'll probably want DateAdd("d", 1, [To]) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data type mismatch in criteria expression. | ian | Running & Setting Up Queries | 2 | December 13th, 2004 06:45 PM |
Writing Criteria Expression | amyfinlay | Running & Setting Up Queries | 1 | October 15th, 2004 03:24 AM |
Data type mismatch in criteria expression | Tcs | Running & Setting Up Queries | 2 | October 8th, 2004 08:05 PM |