Search results

I have a UNION SELECT 0, ' All' FROM tblBrands so that I get an all option in my dropdown. I also have a [Forms]![frmMain]![cboBrands] in my query criteria to filter results from the combo box. When all is selected, I get no results. I'm thinking I need an if statement. if all is selected, run...

I have a form that has 2 combo boxes so far (brand and model). I need model to filter when brand is chosen and I need to pull the data for a query. when the bounded column is 1, my combo box filter works. when bounded column is 2 my query works. Is there a way to leave it at 1 and make the query...

I had 3 drop down filters that worked when the word being filtered was written in the table. I have since then linked them to new tables to be more database-y. The problem I have found (a couple weeks later too) is that my drop downs broke. It makes sense why, they are now 1,2,3,4 instead of...

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 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...

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...