Calculated query

[NoviceIan]

I have two fields; the first is Staff Type (which is a combo box with a value
list) and the second is WTE (Whole Time Equivalent). I am basically trying
to calculate the total WTE for 2 of the 7 Staff Types.

I can get a figure for each staff type and then work it out manually but I
assume there must be a better way so I thought I'd ask the experts. Any
ideas?

Ian

 

[John Vinson]

I have two fields; the first is Staff Type (which is a combo box with a value
list) and the second is WTE (Whole Time Equivalent). I am basically trying
to calculate the total WTE for 2 of the 7 Staff Types.

I can get a figure for each staff type and then work it out manually but I
assume there must be a better way so I thought I'd ask the experts. Any
ideas?

Ian

A Totals Query can do this very readily. Create a Query based on your
table; select the Staff Type field and the WTE field.

Make it a Totals Query by clicking the Greek Sigma icon. Change the
default Group By to SUM under WTE. This will sum the WTE's for all
seven staff types.

If you want to see just two, put

IN("Managers", "Executives")

or whatever on the criteria line under staff type.

John W. Vinson[MVP]

 

[NoviceIan]

That gives me two seperate totals one for Executives and another for
Managers. What I'm looking for is a total for the two.

Using a seperate query I can total the two fields is that the best way?

 

[John Vinson]

That gives me two seperate totals one for Executives and another for
Managers. What I'm looking for is a total for the two.

Using a seperate query I can total the two fields is that the best way?

AH! sorry, misunderstood the question.

Change the Group By under Staff Type to "Where".

John W. Vinson[MVP]