Search results

Awesome!! Worked perfectly. Thanks for the help!

I'm am trying to write criteria for a query to display records with a value between 2 numbers on my form. Also, if these boxes are Null, I want to display all records. I have done a similar thing with all of my other criteria in the query. I used the criteria: Like...

I was able to get the date filter to work, but I am struggling with the filter for the SF of the building. My form is set up as: 'Building SF Between:' [LowGSF] 'And:' [HighGSF] I want my query to find all records with a GSF value between those 2 quantities I type in on the form. If nothing is...

Awesome. That worked much better. I have 2 more small questions: I would like to be able to filter the query for the building square footage as well. I would make 2 text boxes, one for the lowest value, one for the highest. What should I put in the criteria for that query field in order to keep...

Well, I thought I had it figured out. I got it to work using 2 criteria for the query, but when i added criteria to a third field, it wouldn't display any results. Is SQL best option at this point? If so, I'm not to keen on SQL as I am only using Access to help document some projects in my...

Nevermind ... after playing around with the query criteria in SQL view I was able to fix it. For some reason it had some half deleted segments of code in it that were throwing things off. Thanks for the help!

How do I implement an 'Open Query' function in the SQL then, cuz I want my query to display separate, unlike the subform you used in the sample db? Private Sub cmdSearch_Click() DoCmd.OpenQuery(qryDataSheet,[View As AcView = acViewNormal], [DataMode As AcOpenDataMode = acReadOnly]) Dim...

Does this work for multiple criteria in the query tho? Basically I want the query to be filtered according to whatever i select in my form, and if nothing is selected I don't want that field to be used in the filter. I attached my database if that makes it easier. If I select a BuildingType in...

I have a form set up to open a query and filter the results based on the selections in my form. However, I want to set it up to filter the results ONLY IF I make a selection in that control box on the form. Currently, if I make a selection in one box and do not select anything in the next, my...

Is there any way to have multiple values from a multi-selection list box display in separate rows in a query instead of all in the same field separated by commas? Basically i want my query format to be like the format in the attached excel document. THANKS!

Ok, bear with me on this explaination as it is hard to put into words, so i have a working database (attached below). The NewEntry form allows people to enter data for a new job. In this form I have a cascading combo box 'Materials' which displays the available materials when a plumbing...