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
|
|||
|
|||
Multiple parameters in a union query
The prompts are the exact wording you put inside the brackets.
-- KARL DEWEY Build a little - Test a little "Karen" wrote: Thanks Karl. However, the prompts still show up without the language as I wish. Any other suggestions? The search produces the correct results but I can't figure why the prompts do not ask accurately for the information. -- Thanks, Karen "KARL DEWEY" wrote: WHERE [Name] Like "*" & [Enter all or part of employee's name] & "*" AND [Equipment Type] Like "*" &[Enter equipment type] & "*" -- KARL DEWEY Build a little - Test a little "Karen" wrote: I have the following union query SQL language that combines four tables into 1. I'd like for the user to be prompted to enter a bit of the employee's name and then to enter the equipment type for the search. However, when I run the query, the prompts currently read like this: prompt 1: Enter all or part of employee's name], 1 prompt 2: Enter all or part of employee's name], 3 I'd like for the prompts to read like this: prompt 1: Enter all or part of employee's name prompt 2: Enter equipment type Here's my language: SELECT [Name], [Equipment Type], [Equipment #], [Bureau], [Division], [Unit] FROM [Calling Cards] WHERE (([Name] Like "*" & [Enter all or part of employee's name] & "*") AND ([Equipment Type]=[Enter equipment type])) UNION ALL SELECT [Name], [Equipment Type], [Equipment #], [Bureau], [Division], [Unit] FROM [Cell Phones] WHERE (([Name] Like "*" & [Enter all or part of employee's name] & "*") AND ([Equipment Type]=[Enter equipment type])) UNION ALL SELECT [Name], [Equipment Type], [Equipment #], [Bureau], [Division], [Unit] FROM [Pagers] WHERE (([Name] Like "*" & [Enter all or part of employee's name] & "*") AND ([Equipment Type]=[Enter equipment type])) UNION ALL SELECT [Name], [Equipment Type], [Equipment #], [Bureau], [Division], [Unit] FROM [Vehicles] WHERE (([Name] Like "*" & [Enter all or part of employee's name] & "*") AND ([Equipment Type]=[Enter equipment type])) ORDER BY [Name], [Equipment Type]; How do I get the prompts to read like I want. As well, I'm just learning about union queries. What other uses may it have. -- Thanks, Karen |
Thread Tools | |
Display Modes | |
|
|