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
|
|||
|
|||
paramater Queries
We are trying to create a generic paramater query that will work for many
applications. Is there any way to set it up so that certain criteria are not necessary to the query. For instance we have a Type field, a status field, and a date completed field. If the status is in progess we will not have a date completed to enter. |
#2
|
|||
|
|||
paramater Queries
I don't usually add any dynamic criteria to queries. Queries are usually the
record source of forms or reports. Consider using code to build a where clause for the DoCmd.OpenForm method or OpenReport method. I also suggest you don't use parameter prompts. If you have other requirements, please let us know. -- Duane Hookom MS Access MVP -- "JUSTIN HOBBS" JUSTIN wrote in message ... We are trying to create a generic paramater query that will work for many applications. Is there any way to set it up so that certain criteria are not necessary to the query. For instance we have a Type field, a status field, and a date completed field. If the status is in progess we will not have a date completed to enter. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combining Queries | FrankM | Running & Setting Up Queries | 2 | June 16th, 2005 01:21 PM |
How do you find ALL queries used in forms and reports? | M Skabialka | General Discussion | 7 | June 10th, 2005 03:51 PM |
Using calculated fields in multiple queries | Linguist | Running & Setting Up Queries | 6 | May 27th, 2005 02:09 PM |
Access2K append queries fail under XP Pro | [email protected] | Running & Setting Up Queries | 1 | May 25th, 2005 08:46 PM |
Bitwise And | Sam Hobbs | Running & Setting Up Queries | 44 | October 14th, 2004 04:19 AM |