Access Query for Positive Checkboxes

microsoft accessquery

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc.

Say for example i wanted to find staff with military experience, I want to be able to create a query that goes through all employees and only shows the entries that have a tick on the military training checkbox.

My access is a little rusty and reading through other forums all questions relevant to this are much more complicated than mine, or involve VBA.

Any help would be great!

Best Answer

I don't have Access in front of me right now, but if memory serves, you should be able to:

Open your query in Design View
Select your Table/Field
In the Criteria row of the field, enter True (equates to a check in the Check Box)
Save and run your query to confirm the results.

Related Solutions

Merge multiple columns into one via a query in an access database

Maybe this?

SELECT col1 FROM table
UNION
SELECT col2 FROM table
UNION
SELECT col3 FROM table
UNION
SELECT col4 FROM table

UNION only joins distinct values (if you have 4 't' values, it only puts one). UNION ALL will store duplicates.

Combine fields from multiple tables in Access query

What you are looking for is an Outer Join. The default is to do an Inner Join. This little question describes the difference very nicely:

https://stackoverflow.com/questions/38549/sql-difference-between-inner-and-outer-join/38578#38578

Of course, that depicts it with generic SQL - not sure how that relates to Access at all.

The Microsoft page for Outer Joins in Access is here: http://office.microsoft.com/en-us/access-help/creating-an-outer-join-query-in-access-HA001034555.aspx

It should tell you all you need to know.

Best Answer

Related Solutions

Merge multiple columns into one via a query in an access database

Combine fields from multiple tables in Access query

Related Question