|
| 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
August 31st, 2004, 04:12 PM
|
|||
|
|||
Select Criteria in a Query
I was wondering if it were possible to add the select
criteria into a field in the query. Example: when I run a query that pulls information based on a date range, would it be possible to have this date range appear in the query itself? Thanks, John 
|
|
#2
August 31st, 2004, 07:12 PM
|
|||
|
|||
|
Sure, add a new column with an expression like:
Begin Date: [Enter Beginning Date] of course you must substitute your parameter. -- Duane Hookom MS Access MVP "Adding Selected Range into Query" wrote in message ... I was wondering if it were possible to add the select criteria into a field in the query. Example: when I run a query that pulls information based on a date range, would it be possible to have this date range appear in the query itself? Thanks, John
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| select and update query combined | lynn atkinson | Running & Setting Up Queries | 5 | July 15th, 2004 03:48 PM |
| Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
| using combo boxes to select parameter for SQL query | Dogbert Dilbert | General Discussion | 0 | June 16th, 2004 01:45 PM |
| query field reference help | -dch | Running & Setting Up Queries | 4 | June 2nd, 2004 07:30 PM |
Linear Mode
