Adding Field Values

[Srowe]

I am trying to add several different values in a field and display them on a
report. For Example: Field name: products (several different products) Filed
name prodID (number assigned to product):

The fields that I want to add up are the ones that relate to age, sex, and
how many were bought. I would like to be able to total these three criteria
for each product and display them in a report.

Ex: product: DVD------Product id#d145--------Bought by male or female (2
females 2 males etc..) bought by adult or bought by child.

I hope this isn't too confusing. Can Anyone help.

Thanks in advance

 

[Jeff Boyce]

You don't mention where you are trying to add these fields/values.

You don't mention what the underlying data structure looks like ("how"
depends on "what").

If you are trying to combine data from several tables (e.g., customer info,
order info, order item info), use a query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Srowe]

The product field is a combbox which values come from a table. The product id
comes from the same table and is automatically filled in once you chose what
product you want.

These are used in a form with the other fields that I mentioned below. I am
trying to add and display the totals of each field value in a report.

All the fields come from one table and the values that are put in by the
user ie. male/female etc.

I hope this answers your questions.

 

[Jeff Boyce]

I guess I'm still not following how you intend to "add up" gender, age, #
bought, etc. I may be interpreting this too literally, but it doesn't make
"mathematical" sense to me to add age and gender...

Regards

Jeff Boyce
Microsoft Office/Access MVP