True/False Check Box Usage in Forms

[avicknair]

Hello All,



I am not extremely experienced in Access, a little work here and there. I am looking to create a small database where I can search through past jobs completed at my work. I want to be able to assign a sort of keyword to them so I have added a true/false check box and column for each keyword that I have thought of on my data table. If a past job had a chiller and a heat exchanger on it I'd like to be able to check those two boxes and in the future be able to check "chiller" and "heat exchanger" on my form and get the jobs that have those two things on them spit out through the query to me.

My problem is that I am having trouble with the criteria that it takes to run something like this. I have seen that if you just put "yes" in the criteria that it should work but I have had little success with that option. If you have any questions please reply and I'll get back to you! Thank you in advance guys.

[June7]

What does 'little success' mean - error message, wrong results, nothing happens? How does checking boxes on form apply filter to query? Controls used to input filter parameters must be UNBOUND.

Constructing filter criteria that includes multiple yes/no fields as well as other field types can be very frustrating. If you use AND operator, it should work if you manually input fixed parameters directly in query. But if you want to use OR, then it becomes virtually impossible to build with the query designer.

However, if you are using dynamic parameterized query that references UNBOUND controls on form, then this will likely fail to produce desired output.

Post your attempted query SQL statement.

If you want to provide db for analysis, follow instructions at bottom of my post.

[avicknair]

Here is a copy of my database. As you will be able to see, I have a data table with two example jobs that will later be populated with 50 ish along with 5 keywords for search criteria that will later have around 30. In the query, there is text criteria pieces that I am able to cover myself in the criteria, it is only the true/false ones that I am having trouble with.

[June7]

Including the table in the query more than once serves no purpose. You did not show any filter parameters so I have no idea what you tried and failed.

I added some records and selected multiple jobs for one. This query works:

SELECT DataTable.[Estimate ID], DataTable.[Estimate Name], DataTable.Location, DataTable.Year, DataTable.[File Path], DataTable.ACC, DataTable.Biomass, DataTable.Catalyst, DataTable.Chillers, DataTable.CTG
FROM DataTable
WHERE (((DataTable.Biomass)=True) AND ((DataTable.Chillers)=True));

Use VBA to construct WHERE clause from the form selections. Review http://www.allenbrowne.com/ser-62.html

The embedded macro does nothing but open an unfiltered query. Don't open query. Apply filter to a form or open a filtered report.