G
Guest
I have a UNION QUERY where I search for three table with a button control to
activate the query. When I click on the button, parameter pop-up screen
appears and ask for Part #, description and country one at a time. I only
want those three to pop-up one at a time and it work until I added Expiration
Date. Why is there a pop-up parameter screen for expiration date and not
status or registration #. I don't want expiration date parameter to pop-up
from the pop-up screen. Also, is there a way I can put more than one part #
in the parameter pop-up scree (Enter Part #: (35000, 44670, 23233, etc). I
want to be able to enter more than one part # in the pop-up screen using
either comma, or, and to search for more than one part # at once. Thanks.
SELECT [PART_#], DESCRIPTION, [Registration_#], [Expiration Date], COUNTRY,
Status
FROM [Database Table]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
UNION ALL
SELECT [PART_#], [Description], [Registration_#], [Expiration Date],
[Country], [Status]
From [US Registration]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
UNION ALL SELECT [PART_#], [Description], [Registration_#], [Expiration
Date], [Country], [Status]
From [tblcanada]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
ORDER BY country;
activate the query. When I click on the button, parameter pop-up screen
appears and ask for Part #, description and country one at a time. I only
want those three to pop-up one at a time and it work until I added Expiration
Date. Why is there a pop-up parameter screen for expiration date and not
status or registration #. I don't want expiration date parameter to pop-up
from the pop-up screen. Also, is there a way I can put more than one part #
in the parameter pop-up scree (Enter Part #: (35000, 44670, 23233, etc). I
want to be able to enter more than one part # in the pop-up screen using
either comma, or, and to search for more than one part # at once. Thanks.
SELECT [PART_#], DESCRIPTION, [Registration_#], [Expiration Date], COUNTRY,
Status
FROM [Database Table]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
UNION ALL
SELECT [PART_#], [Description], [Registration_#], [Expiration Date],
[Country], [Status]
From [US Registration]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
UNION ALL SELECT [PART_#], [Description], [Registration_#], [Expiration
Date], [Country], [Status]
From [tblcanada]
WHERE [PART_#] Like "*" & [Enter Part #:] & "*" and [Description] Like "*"
& [Enter Description:] & "*" and [Country] Like "*" & [Enter Country:] & "*"
ORDER BY country;