Parameter value

  • Thread starter Thread starter Angeliki
  • Start date Start date
A

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
 
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.
 
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
 
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

John Spencer (MVP) said:
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.
Click to expand...
Click to expand...
 
Back
Top