Query Help...

[Guest]

HI EVERY BODY,
I HAVE A TABLE IN WHICH TWO FIELDS ARE PLANT & AREA LIKE

PLANT AREA
UDD OA1
SP OA1
MTBE OA1
STY1 OA2
STY11 OA2
CFC OA3
PW OA3

I MADE THREE SEPERATE PARAMETER QUERY FOR EACH AREA.
I USED LIKE OPERATOR (e.g LIKE[OA1],LIKE[OA2]...) FOR USING THE '*'(ASTERIC)
IN MY EACH QUERY SO THAT ,WHEN I PUT ASTERIC AS A PARAMETER VALUE IT SHOULD
GIVE
ALL THE RECORDS IN THAT PARTICULAR AREA.
BUT IT IS NOT HAPPENING.
WHEN I PUT ASTERICS AS MY PARAMETER VALUE IT RETURNS THE RECORDS OF ALL
THE AREA.
Hopefully i expalined U
PLS HELP ME TO SOLVE THIS PROBLEM.

WARM REGARDS,
NAD

 

[John Spencer]

Answered in your earlier post. Please be patient. This is a volunteer
group and sometimes it takes 24 or more hours before someone will see and
respond to your request for help.