MS Access Remove Lines with strTrainLevel value of anything other than null or 0 from report.

I have a report created in an access database that will list all employees and their training level for a particular class:
0 -  needs the training
1- Can do the task with supervision        etc......

Now when I run my report it includes all people and their status for that class, but what I would like is for the report to only list people with a strTrainLevel value of 0 or null so that I can run this report monthly and know who has training coming up or who needs it....

The report is named rptTrainingForAClass

I have attached the DB. This was an example database I found on the internet for free and doesn't contain any info about my company.
Training-Database-with-Gender--1-.zip
MarcVisteAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GozrehCommented:
Filter the query "WHERE (((qryRecordsQuery.strTrainLevel)=0 Or (qryRecordsQuery.strTrainLevel) Is Null))"
Training-Database.zip
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MarcVisteAuthor Commented:
Where are you findin the specific query? I'm new to the access thing...
0
GozrehCommented:
I upload the file, look in the recordsource of the report
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MarcVisteAuthor Commented:
Did you make the change in the database you uploaded? I went to recordsource in the reports properties and I see queries, but all I see is:
qryRecordsQuery

So when I try to add your text there it complains about not being in the list. Does that matter, or am I in the wrong place altogether?
0
GozrehCommented:
I already added the where statement to the query.
just run this report to see the result.
0
MarcVisteAuthor Commented:
I guess I  just wanted to look at the query itself so I could see your change.  Can you tell me where I need to look? I want to learn this so if I need to make additional changes I have at least some semblence of an idea on where to go. :)
0
GozrehCommented:
I changed the criteria from query "qryTrainingForAClass" to:
"SELECT qryRecordsQuery.strProcNum, qryRecordsQuery.[Procedure Title], qryRecordsQuery.strProcRev, qryRecordsQuery.strEmpNum, qryRecordsQuery.Name, qryRecordsQuery.dtmDate, qryRecordsQuery.strTrainLevel
FROM qryRecordsQuery
WHERE (((qryRecordsQuery.strTrainLevel)=0 Or (qryRecordsQuery.strTrainLevel) Is Null))
ORDER BY qryRecordsQuery.strProcRev, qryRecordsQuery.strEmpNum, qryRecordsQuery.dtmDate;"

You can read more about query criterias Examples of query criteria
0
MarcVisteAuthor Commented:
I've looked in queries, Ive looked in the properties for the button click on the run report button, etc... can you tell me exactly where you made the change? I need to snag that snipet of code and drop it into the actual database I use since the one provided has dummy data...

Sorry this is taking so long....
0
GozrehCommented:
Go to the properties of your report "rptTrainingForAClass", under Data - Record Source
click next to "qryTrainingForAClass"
qryTrainingForAClass.png
0
MarcVisteAuthor Commented:
I am there and I see what you do on the picture provided, I am just not seeing where you made the change. There is no block of text that size on the screen. I have moved through all of the items in qryRecordsQuery window and mucked around in all of the fields, but don't see where you made a change....
0
GozrehCommented:
look on the last field in that query i added the criteria "0 Or Is Null",

You should read more about query criteria here Examples of query criteria
qryTrainingForAClass.png
0
MarcVisteAuthor Commented:
Oh wow, right in bloody front of me. I was looking for that entire code snippet you had posted earlier in this thread. So sorry!  Thanks a ton, and I will go read about those now.
0
MarcVisteAuthor Commented:
Really worked through this with me even though I was not seeing what he had changed. Very good job, thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.