User defined field in query for yes/no question (1 Viewer)

[mounty76]

Good Morning!

I want to add a temporary field to a query that prompts the user for a yes or no answer. I can do this by putting something like " ILL: [Has person been ill] " in the query field, Only issue (and this is really first world problems! haha) is that the user has to type in Yes or No. Is it possible for the popup box when the query is run to just have two boxes YES and NO? FYI there is data from a few other tables/queries in this same query and the results are needed for a report.

Any help much appreciated!

Cheers

 

[arnelgp]

of course you can do that in query.
you already constructed the Expression for you query:

ILL: [Has person been ill? (Y/N)]

 

[CJ_London]

popup boxes as you describe are fine whilst developing but don't really have a place in a production application. What if the user doesn't type Y or N but something else or leaves blank?

Better to have a form where the user can select from a list of possible options ('Yes','No') and the query refer to that

 

[mounty76]

OK thanks for this, agree better to have a popup form with the questions, thanks guys