Search results

I'm not sure about the null or zero. I'm not sure how to test it. They "SHOULDN'T BE" since I use them since I can see the results in another query that concatenates them into a string. Also, I am assuming they are numbers since the division works when not in an iif statement. Maybe I should...

This is what I got but it gives #error Expr1: IIf([query1]![field1]=0,0,[query2]![field2]/[query1]![field1]) It works without the IIF except for the need to catch the DIV/0 error [query2]![field2]/[query1]![field1] I also tried Expr1...

I started playing with the noodles and connected the table to a query and it gave me what I was looking for. Kind of shocked myself. SELECT Baseline.MDS, countCBI.CBI FROM Baseline LEFT JOIN countCBI ON Baseline.MDS = countCBI.MDS GROUP BY Baseline.MDS, countCBI.CBI; Thanks everyone for...

I'm still trying it. All the tutorials I have found have been for 2 tables. Mine are currently in one table and things were counted by queries. Maybe this was wrong way to set up?

I was told by a coworker that I explained my issue poorly. I have uploaded a picture of what I am trying to achieve. I apologize for the bad writing, I was still waking up when I made it. I'm still going through all your suggestions at the moment. ***EDIT*** Yes I am new to this software...

I honestly have no Idea. I touched mySQL when I was in school and this is my first time in access. Most of what I have been done is with the GUI and tutorials. I'm looking at it like it's a huge mess but haven't figured out how to do it right. So basically I am trying to make a product while...

I have seen a bunch of others with this question but I can't get the solutions to work. I have tried Nz and IIf but maybe not correctly. Would some one please help me understand how to make my query produce zeros instead of nothing at all. SELECT Baseline.MDS, Count(Baseline.[Lesson Type]) AS...

looking through my query results, it looks like that may be the issue. I guess I need to make them offer 0 in what they put out.

Sorry for the late reply. The wife wouldn't let me do work on the weekend and made me do yard stuff :mad: . I can't give you what I am working on but I did strip the DB and add car names in replacement. There is a lot of abbreviations that some one here knows what they mean but the only ones I...

Hello, I’m new to Access so please don’t hate me. I did look for a solution but wasn’t sure what I was looking for. I have a table with a bunch of lessons on them. In it, I have 8 vehicles and 6 lesson types. I am trying to generate a report that tells me how many are discussion and how many...