Querie with multiple variables

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

Jimbo

I have two tables, 1st is list of employees working by hour, and 2nd
is state licensure.

I want to sort by state licensure and by hour increments. Basically,
I want to know by hour how many employees do I have working in any
given state.

How can I do this?

Thanks in advance.
 
In a new query, bring both tables, join them through their common field
(employeeID), Bring the field licensure, sort it (ascending or descending as
required), bring the working hour field, sort it too. That's all.

Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with 1
Help with pivot table 2
Queries using Calculations 6
Subquery in Form 1
Filter Query 2
Combining Multiple Records in Queries 1
Query Comparing Two Tables 3
"and" criteria 1

Back
Top