Sum

[rickyzicky]

I have the following records:

1 O2 Bottle Serial # 101
1 O2 Bottle Serial # 102
1 O2 Bottle Serial # 103

-------------------------
I would like the report to display
the sum of the bottles (3) and have a drop down box show the serial #'s next to the description.

I can't sum with the serial numbers showing.

Any suggestions?

 

[Blorf]

This in a form or just a query?

Ascii dumb question, get a dumb Ansi

 

[rickyzicky]

Let me clarify. This would be a report.
I would like to sum on the QTY field.
I also would like a drop down box to appear only when the serial number field is not null for that record.

I can change to a form if necessary.

RZ

 

[lespaul]

I don't think you can have a drop down box in a report??

 

[dhookom]

YOu can put a dropdown in a report but it won't have any functionality other than to display a value.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rickyzicky]

OK...can I somehow sum on the quantity field where the decriptions field matches even thouhgh the serial number field is different.

I would like to display the individual serial numbers as well on the same form/report.

Thanks

 

[dhookom]

Do you have any field names associated with?
1 O2 Bottle Serial # 101
1 O2 Bottle Serial # 102
1 O2 Bottle Serial # 103

What would you expect your display in the report to look like?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rickyzicky]

I would like the qty to be added based on the desc field.

3 O2 Bottles [perhaps a drop down box with the individual serial #'s here]

I simply want to combine the total o2 bottles, but keep it's individuality for maintainenece purposes based on serial #.

 

[dhookom]

So, we can assume the first column is a quantity column? You can create a grouping level in your report that is based on the field [Desc]. Display the group footer and add a text box with a control source of:
=Sum([Qty])
If you don't want to see the detail section, you can make it invisible.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.