By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,647 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Access Forms

P: 2
I designed a form that has job titles and a dropdownlist to select the state. Each job title has a checkbox. I built a query to query a table (tblPostions) which contains the following:

Positions
Hourly Rate
City
State

The other table (tblState) just has a list of all the states in the U.S. The query that I have made pulls back all the fields from tblPositions according to the state selected from the dropdownlist. I was wondering if there is a way to have only the checked positions pulled back when the query runs?
Dec 5 '07 #1
Share this Question
Share on Google+
2 Replies


Denburt
Expert 100+
P: 1,356
If you look at the SQL for the query it should like something like this.

Select Positions, Hourly Rate,City,State from tblPostions

Adding a where clause should solve the issue

Select Positions, Hourly Rate,City,State from tblPostions Where [job title] = true
Dec 5 '07 #2

Nathan H
100+
P: 104
I designed a form that has job titles and a dropdownlist to select the state. Each job title has a checkbox. I built a query to query a table (tblPostions) which contains the following:

Positions
Hourly Rate
City
State

The other table (tblState) just has a list of all the states in the U.S. The query that I have made pulls back all the fields from tblPositions according to the state selected from the dropdownlist. I was wondering if there is a way to have only the checked positions pulled back when the query runs?
Add the checkbox field to your query and then in the criteria line put YES. (You may have to try TRUE or ON depending on the format of your checkbox)
Dec 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.