can't get sum in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm a very basic user, so please excuse me if this sounds relatively
elementary. I have a report based off of a crosstab query. I would like to
create a sum in the middle. I can't get it to work. It looks like this.

Date inv# cust totalsold prod1 product2 product3 product4
2/4 1234 bob 12 1 4 3 4

i would like it to look like this:
Date inv# cust totalsold prod1 product2 total 1&2 product3 product4 Total
3&4
2/4 1234 bob 12 1 4 5 3
4 7

If anyone could help, I would appreciate it. I have spent hours trying to
figure this out.

G
 
Do you actually have repeating field like this? If so, what happens if you
create a text box in your report with a control source like
=[Prod1]+[Prod2]
 
G said:
i'm a very basic user, so please excuse me if this sounds relatively
elementary. I have a report based off of a crosstab query. I would like to
create a sum in the middle. I can't get it to work. It looks like this.

Date inv# cust totalsold prod1 product2 product3 product4
2/4 1234 bob 12 1 4 3 4

i would like it to look like this:
Date inv# cust totalsold prod1 product2 total 1&2 product3 product4 Total
3&4
2/4 1234 bob 12 1 4 5 3
4 7

If anyone could help, I would appreciate it. I have spent hours trying to
figure this out.
Click to expand...


Assuming the crosstab query always has the prod1, orid 2,
etc columns, open the report in design view. Drag the
controls around to make room for the totals. Then, add two
new text box controls in the appropriate places and set
their control source expressions to something like:

= prod1 + prod2
 
if i enter = prod1 label +product 2 label, i get an error message
If I enter = prod1+prod2, only 1line resulted in a return

Duane Hookom said:
Do you actually have repeating field like this? If so, what happens if you
create a text box in your report with a control source like
=[Prod1]+[Prod2]

--
Duane Hookom
MS Access MVP
--

G said:
i'm a very basic user, so please excuse me if this sounds relatively
elementary. I have a report based off of a crosstab query. I would like
to
create a sum in the middle. I can't get it to work. It looks like this.

Date inv# cust totalsold prod1 product2 product3 product4
2/4 1234 bob 12 1 4 3 4

i would like it to look like this:
Date inv# cust totalsold prod1 product2 total 1&2 product3 product4
Total
3&4
2/4 1234 bob 12 1 4 5 3
4 7

If anyone could help, I would appreciate it. I have spent hours trying to
figure this out.

G
Click to expand...
Click to expand...
 
You should be entering the expression in a text box in the report, not in
the criteria of the query. If your derived column names have spaces in them,
then you need to wrap your column names in []s.

--
Duane Hookom
MS Access MVP


G said:
if i enter = prod1 label +product 2 label, i get an error message
If I enter = prod1+prod2, only 1line resulted in a return

Duane Hookom said:
Do you actually have repeating field like this? If so, what happens if
you
create a text box in your report with a control source like
=[Prod1]+[Prod2]

--
Duane Hookom
MS Access MVP
--

G said:
i'm a very basic user, so please excuse me if this sounds relatively
elementary. I have a report based off of a crosstab query. I would
like
to
create a sum in the middle. I can't get it to work. It looks like
this.

Date inv# cust totalsold prod1 product2 product3 product4
2/4 1234 bob 12 1 4 3
4

i would like it to look like this:
Date inv# cust totalsold prod1 product2 total 1&2 product3 product4
Total
3&4
2/4 1234 bob 12 1 4 5 3
4 7

If anyone could help, I would appreciate it. I have spent hours trying
to
figure this out.

G
Click to expand...
Click to expand...
Click to expand...
 
Back
Top