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
 
Back
Top