Trouble shooting a query

I have a database which collects sales for a company that sells burrito's.
We deliver a certain number and a certain number is wasted. The Difference
between these two numbers is the Sold amount. We bill based on the Sold and
the Wasted. Therefore, i need to do a subtraction in a calculated field in a
query. No problem. that works perfectly. The query shows the balance. But
I want to copy the query to an excel spreadsheet and do a pivot table. When
I do that, there are three of these calculations that show up as "counts' not
"sums" because the Pivot is adding all the numbers together. But because
those three are looking like counts, I get a "1" for each other of them
instead of a sum.

I've looked at the query and redone the calculating field and formula and
nothing works. These three records are newly added to the table and the
query, so that is the only indication that something went awry when I added
them to the previous version of the table / query. But I did everything
exactly the same (I think) and I've wracked my brain to solve the problem and
can't. any thought? I've sent you a page shot of the pivot table process
that shows the problem. Can I fix this without redoing the whole database?

Brigid -

It sounds like the issue is in your pivot table in Excel. You can change
the 'count' to 'sum' by right-clicking on the field in the pivot table and
selecting Field Settings.

--
Daryl S


"Brigid" wrote:

I have a database which collects sales for a company that sells burrito's.
We deliver a certain number and a certain number is wasted. The Difference
between these two numbers is the Sold amount. We bill based on the Sold and
the Wasted. Therefore, i need to do a subtraction in a calculated field in a
query. No problem. that works perfectly. The query shows the balance. But
I want to copy the query to an excel spreadsheet and do a pivot table. When
I do that, there are three of these calculations that show up as "counts' not
"sums" because the Pivot is adding all the numbers together. But because
those three are looking like counts, I get a "1" for each other of them
instead of a sum.

I've looked at the query and redone the calculating field and formula and
nothing works. These three records are newly added to the table and the
query, so that is the only indication that something went awry when I added
them to the previous version of the table / query. But I did everything
exactly the same (I think) and I've wracked my brain to solve the problem and
can't. any thought? I've sent you a page shot of the pivot table process
that shows the problem. Can I fix this without redoing the whole database?