Report sum problem

[NoviceIan]

Hi,

I basically have a report which is populated by a query. It basically lists
different types of staff and then gives totals for heads and wte (whole time
equivalent). At the bottom of the report I total up heads and wte using a
sum and textbox.

Vacancies is one of the staff types and when there are vacancies it all
works fine but if there are not any vacancies the wte for vacancies is blank
and as a result so is the total textbox.

What am I doing wrong?

Thanks Ian

 

[Duane Hookom]

Can you share more information such as your table structure, a few sample
records, expected results display, and current results display?

 

[NoviceIan]

The tables involved are Staff and Vacancy. I get the Heads figure by
counting up the number of staff numbers and the wte is simply a sum. This is
is the same for vacancy only I count the vacancy number.

The other field involved is the Staff Type field which seperates the
different types of staff for the report. Below is an example of the results
I get when there are vacancies.

Staff Heads WTE

Qualified 20 16.5
Unqualified 5 2.5
Admin 5 4
Vacancies 2 2

Total 32 25

However If there are no vacancies then the results are like those shown below

Staff Heads WTE

Qualified 20 16.5
Unqualified 5 2.5
Admin 5 4
Vacancies

Total 32

Is that any help?? Thank you for taking the time to help.

Ian

 

[Duane Hookom]

Can you share more information such as your table structure, a few sample
records, expected results display, and current results display?