Calculating number of people based on shift pattern, MS Access

Asked By Blossom Serrano 0 points N/A Posted on - 03/29/2012

I want to calculate the number of people from certain province in a party. Now the problem comes because it has to go with the shift pattern. I tried to do it by myself, but things got a little messy.
Thanks for your help.

• Status: Open
• Question Views: 1085
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Ratyr patsr 0 points N/A #116479

Calculating number of people based on shift pattern, MS Access

 

First we need to know the attributes of the table you are using. I assume you are using a table with the following attributes.

1. Name

2. Province

3. ID_number

4. etc….

Just you need to find the number of people of a province, then all you need to do is to write a very simple SQL query that is used to count the number of tuples based on a province. Use the below

Select count(*) from <table name>

where province=’<province name>’;

Here the count(*) counts and reports the number of rows / tuples that are found to be of the same province with the given province name.

If you need the province name to be extracted from a string, then use the function SUBSTR.

Thanks.

 

About Ratyr patsr

Questions
0

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 05/10/2012
• Question Category: MS Access