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
|
|||
|
|||
Criteria in a query
In a select query I have added a criteria to a field as ["Enter
Department:"]. If no department is entered in the box that is prompted, I get no results. How do I make the query to display all departments, if no department is entered in the prompt box? Thanks for the help |
#2
|
|||
|
|||
Krish,
Change your criterion in the query design to: Like ["Enter Department:"] & "*" HTH, Nikos "Krish" wrote in message ... In a select query I have added a criteria to a field as ["Enter Department:"]. If no department is entered in the box that is prompted, I get no results. How do I make the query to display all departments, if no department is entered in the prompt box? Thanks for the help |
#3
|
|||
|
|||
On Thu, 23 Sep 2004 07:46:14 -0400, Krish wrote:
In a select query I have added a criteria to a field as ["Enter Department:"]. If no department is entered in the box that is prompted, I get no results. How do I make the query to display all departments, if no department is entered in the prompt box? Thanks for the help Where YourTable.[Department] = [Enter Department] or [Enter Department] Is Null -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Corrupted" query | Jeff J | Running & Setting Up Queries | 8 | August 12th, 2004 07:51 PM |
UNION Query with Criteria | Dkline | Running & Setting Up Queries | 1 | August 4th, 2004 09:15 PM |
Multiple Criteria for Query | Eric | Using Forms | 2 | June 23rd, 2004 03:09 PM |
exclude statement for query criteria | GitarJake | New Users | 2 | June 15th, 2004 07:52 PM |
Query criteria doesnt use year input | Donna Brooks | Running & Setting Up Queries | 3 | May 29th, 2004 03:57 AM |