Hi all,
It's been a while since I have posted.
I have an Access database that manages case notes for my student's examinations. They use it to create case notes, and then export them as 'reports' to PDF for me to review. However, the beauty of it, is that I have set up some queries so the students can run them to get the data they need from other student examinations and use that information for discussion points and conclusions.
Recently, I created a query that would give the students a list of 'case numbers' and how many times a chemical batch was used - this information is stored in a separate linked table.
I have noticed though that if a student doesn't use a chemical throughout their examination, the query doesn't even show case number at all. I want it to show the case number and a 0 for the chemical batch.
So I thought I would design a simple aggregate query and use the Nz( ,0) function to do it. But when I run the query it still doesn't show me the case number and the 0 ! Its just ignored... Am I doing something wrong? The images below have some information blurred for privacy reasons...
This is my query.....
This is when I run it, its still not showing examinations with 0 they are just ignored!?
I'm pretty sure Nz is the fuction /expression I need to use but its just not working
Any help will be appreciated !