What Am I Missing or Not Doing - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

What Am I Missing or Not Doing

Lee Shastid

6 months ago

I have a query setup for a search box. I get all my results when i run the query. one of the fields i have 3 options included, added, or missing. my search criteria is on multiple fields and i get the results from each field individually. Example is if I run a search and use the word Missing I get all my results just fine. However if I run a search on a particular product I will get the results for that field showing included, or added but not the missing one. What am I doing wrong or not doing?

	Kevin Robertson @Reply 6 months ago
We can't possibly help without seeing what you have done. Please show screenshots and any VBA code you may have. Please be more specific. See Rule #2.

	Lee Shastid OP @Reply 6 months ago
Kevin It wasn't I was not trying to be specific but I really couldn't explain it better. I have changed my joins several times and nothing changed the outcome. I ran the compact and repair database and it may have fixed it. I will keep working on it and if it changed I will post some screen shots of what I think would explain it better. Thank you for your time and patience

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View