Hi,
I'm running Access 2010 and have a form with an option group that people can click to filter a query (which displays in a list box) with "Accepted", "Declined" or "Show All".
It works great if I choose the Accepted option (value of 1) or the Declined option (value of 4), but I'm having trouble making the Show All option work (value of 99) - it doesn't display any results. Can you help...
2 results in 0.0023 seconds.
-
Query filtered by Option Group - how to Show All?
-
How to use If, Then, Else inside of a query
I have a customer table (user created and tech support took over) which holds basic customer data - names, address, etc. There is no primary key on this table and no data validations (YET). I have been asked to create a label report that will gather info from table and make labels. Easy to do.....BUT they want the labels to read Mr. & Mrs if the customers are married. There is a field which is home to "spouse name", and a duplicate...
