stretch66
Racing towards the start
- Local time
- Today, 23:45
- Joined
- Sep 28, 2005
- Messages
- 72
Hi,
Brand new to this! And have been trying all morning!
Have a field in a table called Job_Status which can have three values:
Permanent = 1
Temporary = 2
Probationary = 3
All I wanted to do was create a query that showd me the totals of all employees plus the number of perm,temp and probationary staff.
Have tried select query and can only get it to display one value at a time and got completely thrown with the crosstab queries.
Can anyone help walk me through the process?
Brand new to this! And have been trying all morning!
Have a field in a table called Job_Status which can have three values:
Permanent = 1
Temporary = 2
Probationary = 3
All I wanted to do was create a query that showd me the totals of all employees plus the number of perm,temp and probationary staff.
Have tried select query and can only get it to display one value at a time and got completely thrown with the crosstab queries.
Can anyone help walk me through the process?