Query Functions

[Leslie]

I have a spreadsheet with employee data by city and
state. In my query, I need to count the number of
employees by state. Can anyone help?

 

[PC Datasheet]

Open your query in design view. Click on the Sigma button in the toolbar at the
top (looks like a "W" turned sideways). In the employees field in your query,
click the down arrow at Group by and select count. Leave state as Group By. Run
the query now and you will get the number of employees by state.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

 

[Steve]

If you go into your Query editor in Design view and try
inputting a formula for excel which is Countif etc.
Another site which might be able to help you is
www.mrexcel.com - they respond with 1hr!

 

[Mark]

Sort your data by State.
Add subtotals at every change in State and count

 

[Leslie]

This process added 1' to this column. There weren't any
totals. Any suggestions?