Querie with multiple variables

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.
 
V

vanderghast

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
look up by multiple variables 1
Help with pivot table 3
Sorting Multiple Tables 1
Style Header Reformatted 3
How to implement two shifts per day with multiple teams 0
Tracked changes by multiple people modified to one 0
Multiple Email Accounts and Calendars 0

Top