 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Adding Field Values
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 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 >I am trying to add several different values in a field and display them on >a [quoted text clipped - 13 lines] > > Thanks in advance 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. > You don't mention where you are trying to add these fields/values. > [quoted text clipped - 26 lines] > > > > Thanks in advance 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 > The product field is a combbox which values come from a table. The product > id [quoted text clipped - 45 lines] >> > >> > Thanks in advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.