Parameter value

[Angeliki]

I define a parameter value in a query. However if i want to see only a
specific data
it's ok but can you tell me what parameter value should i enter in order to
show me all the data
of the query?? i tried * but it does not work.

thanks in advance
Angeliki

 

[John Spencer (MVP)]

Can you post the SQL of the query that is not working. It is really hard to say
what the problem is.

A big guess is that you are using the equals operator instead of the Like
operator in your criteria.

 

[Angeliki]

This is the SQL code for my criteria.I want to be able to choose either one
contract reference of all in once.
Can you please tell me what is wrong with the code?
WHERE (((IIf([Contract_Ref]="NTU","NTU",IIf([Contract_Ref]="NTU (S)","NTU
(S)",IIf([Contract_Ref]="Declined","D","WRITTEN"))))=[enter profile]));
Thanks
Angeliki

 

[John Spencer (MVP)]

Try

WHERE IIf([Contract_Ref]="NTU","NTU",
IIf([Contract_Ref]="NTU (S)","NTU (S)",
IIf([Contract_Ref]="Declined","D",
"WRITTEN"))) LIKE [enter profile];

This is the SQL code for my criteria.I want to be able to choose either one
contract reference of all in once.
Can you please tell me what is wrong with the code?
WHERE (((IIf([Contract_Ref]="NTU","NTU",IIf([Contract_Ref]="NTU (S)","NTU
(S)",IIf([Contract_Ref]="Declined","D","WRITTEN"))))=[enter profile]));
Thanks
Angeliki

Can you post the SQL of the query that is not working. It is really hard to say
what the problem is.

A big guess is that you are using the equals operator instead of the Like
operator in your criteria.