Problem with inputing criteria for query?

[nhat2991]

I'm making a query so user can look for orders which are completed or not

SELECT Orders.Order_ID, Orders.Order_date, Orders.Order_complete
FROM Orders
WHERE (((Orders.Order_complete)=[Please enter]));

My problem is I cannot type in "Yes" or "No" when I was asked to input the value. Is there any way possible to fix this because the query works fine if I change it to this.

SELECT Orders.Order_ID, Orders.Order_date, Orders.Order_complete
FROM Orders
WHERE (((Orders.Order_complete)=Yes));

Thanks

[DonRayner]

I'm assuming that your Yes or no is going into a yes/no (bit) type field. If so your query would need to have this added at the beginning

PARAMETERS [Please enter] Bit, so your sql code would look like this

PARAMETERS [Please enter] Bit;
SELECT Orders.Order_ID, Orders.Order_date, Orders.Order_complete
FROM Orders
WHERE (((Orders.Order_complete)=[Please enter]));
 

[NeoPa]

It seems you're confusing Yes with "Yes".

Yes is a boolean value representing True (numerically -1), whereas "Yes" is a string value representing (You got it - "Yes").

[nhat2991]

Thanks for all the reply guys, my problem was solved.

[NeoPa]

Very pleased to hear that :)

Welcome to Bytes!