Search results

Desert vs. Canadian border/mountain snow is a constant debate in my house too! My partner grew up in the mountains, and we've both lived in states where 6"+ of snow in one storm is common. I'm sure one day we'll be some variant of Snow Birds--ha! It actually snowed here for about half an...

It appears things were just too messy and out of order. I made a new query, and was careful to put my parameters in order/together in the design grid, and now it's working again! Now to solve my next problem--but that's another thread! Ha! Thank you, @theDBguy for recommending I look at VBA...

A transplant to Arizona, yes :)

I'm super new to this so I don't fully understand what you're saying. Than you for being patient with me. The user does not need to fill in every field to search. For example, they can just search for color and garment type, leave all the other cbo boxes blank, and it will return all records...

@Isaac Yeah..... when I added in the bit to display records with Null values (as not every field for every record will get filled in) it got a bit....large. :)

Ha! I missed that it was too large when I tried to upload it with my previous reply. There's a zip attached to this one.

My full SQL is too long to post. I'm very new to all of this, so for the most part I've been letting Access do a lot of the heavy lifting, so the SQL is rather long and messy. Everything else is working really well, I added each criteria one by one to make sure, and this one is my problem...

I've written a search query to search tbl: Inventory with cbo boxes to select the criteria on a form. I have one criteria that is not filtering and I can't quite figure out why--it is set up exactly like all the others. SELECT Inventory.Photo1, Inventory.InventoryID, Inventory.SetID...

Hello! I'm new to all the things. I work in live performing arts and am using this um.....slower.....time to learn some new skills so I'm using Access to help streamline some of our production shop processes and inventory management systems at my company. I'm smack in the middle of the...

@plog Thanks! Do I need to include the table before setID in the brackets at the end. So it would be AND IsNull (tblName.SetID),0,1)

@plog Thanks! I'm still pretty new at this. If I'm working in query design view, where would that first line you typed go? Is that it's own column?

I've done a search through the forums, and found a couple threads that are similar, but I don't fully understand the answers. I have a query with various parameters on a form the user can select from combo boxes. I'd like to add a check box so that if it is ticked it will exclude any record...

@pbaldy Grand! It worked! Thank you so much! I've spent an absurd amount of time trying to figure that out--ha!

@pbaldy would I still need to include the LIKE statement with that? If so, would it be on both of them? so it would read: like "*"&[Forms]![myForm]![myControl]&"*" OR [Forms]![myForm]![myControl] Is Null

Hello! I'm a very beginning beginner with both Access and any kind of coding. I'm running into a rather interesting issue with a select query with parameters not returning records that contain a specific value, even though they should be returned. I've posted in another forum, and the...