# Getting Totals and Restricted data

G

#### Guest

Hello all,

I have a variance report based upon a query. In the query and report, I
only show the items that do have a variance: So in my query I have something
like this

Var: [Inventory A] â€“ [Inventory B]
Criteria: <>0

Data
Inventory A Inventory B

10 10 Do not show
2 3 Show variance 1
4 2 Show variance -2
4 4 Do not show

Report Shows
Inventory A Inventory B Variance

2 3 1
4 2 -2

Easy enough for this, but I would also would like to get the totals for
Inventory A not based upon the variance.

Inventory A Inventory B Based upon numbers above
20 19

Is there a way to sum the qty fields on my inventory then show a variance
without having to make 2 reports?

Report view wanted

Inventory A Inventory B Variance

2 3 1
4 2 -2

Totals
Inventory A Inventory B
20 19

Rather than filter your data in the query, do it in the report. Say you have
a text box on the report for variance (txtVar) Then in the Control Source
for the variance:

IIf([Inventory A] â€“ [Inventory B] = 0, "", [Inventory A] â€“ [Inventory B])

I have 4 fields in the report: Sku, InvA, InvB, and Var. Would this allow me
to surpress this line (all 4 fields) if variance is = to 0? Or would I have
to write this to each field?

Klatuu said:
Rather than filter your data in the query, do it in the report. Say you have
a text box on the report for variance (txtVar) Then in the Control Source
for the variance:

IIf([Inventory A] â€“ [Inventory B] = 0, "", [Inventory A] â€“ [Inventory B])

Mark said:
Hello all,

I have a variance report based upon a query. In the query and report, I
only show the items that do have a variance: So in my query I have something
like this

Var: [Inventory A] â€“ [Inventory B]
Criteria: <>0

Data
Inventory A Inventory B

10 10 Do not show
2 3 Show variance 1
4 2 Show variance -2
4 4 Do not show

Report Shows
Inventory A Inventory B Variance

2 3 1
4 2 -2

Easy enough for this, but I would also would like to get the totals for
Inventory A not based upon the variance.

Inventory A Inventory B Based upon numbers above
20 19

Is there a way to sum the qty fields on my inventory then show a variance
without having to make 2 reports?

Report view wanted

Inventory A Inventory B Variance

2 3 1
4 2 -2

Totals
Inventory A Inventory B
20 19