parameter query

[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 ASTERICs 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.
PLS HELP ME TO SOLVE THIS PROBLEM.

WARM REGARDS,
NAD

 

[John Spencer]

First, stop shouting. ALL CAPITAL LETTERS is considered the equivalent of
shouting and it is hard to read.

If you mean you want to query your records and return all those in the areas
that start with OA then you would need to enter
"OA*" as your parameter. Just entering "*" means return all records where
there is any value in the field.

If that is not what you mean then tells us what you want returned when you
enter an asterisk. Using your sample data which records would you want
returned?

 

[Guest]

Sorry.... for shouting
if i will put OA* it will display all the area.
i have seperate query for each area.(e.g. OA1query,OA2query,...)
i just want, when i put * the query AO1query display all the records of
the area OA1 not all.

Thx

First, stop shouting. ALL CAPITAL LETTERS is considered the equivalent of
shouting and it is hard to read.

If you mean you want to query your records and return all those in the areas
that start with OA then you would need to enter
"OA*" as your parameter. Just entering "*" means return all records where
there is any value in the field.

If that is not what you mean then tells us what you want returned when you
enter an asterisk. Using your sample data which records would you want
returned?

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 ASTERICs 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.
PLS HELP ME TO SOLVE THIS PROBLEM.

WARM REGARDS,
NAD

 

[John Spencer]

I am sorry, but I don't understand what you are trying to do.

Why do you have separate queries for each area? You should have one query
and a parameter that specifies which area you want.

Please copy and post the SQL of one of your queries.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Perhaps that will enable someone to see what you need to do.

Sorry.... for shouting
if i will put OA* it will display all the area.
i have seperate query for each area.(e.g. OA1query,OA2query,...)
i just want, when i put * the query AO1query display all the records of
the area OA1 not all.

Thx

First, stop shouting. ALL CAPITAL LETTERS is considered the equivalent
of
shouting and it is hard to read.

If you mean you want to query your records and return all those in the
areas
that start with OA then you would need to enter
"OA*" as your parameter. Just entering "*" means return all records
where
there is any value in the field.

If that is not what you mean then tells us what you want returned when
you
enter an asterisk. Using your sample data which records would you want
returned?

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 ASTERICs 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.
PLS HELP ME TO SOLVE THIS PROBLEM.

WARM REGARDS,
NAD