Beginner Access problem - Help!!! :-(

[bruce]

What is in the year field? What data type is that?

Just print all the data in a couple rows.

[b]quote:Originally posted by socks4

Hi, I don't know SQL too well. I taught myself a few years ago and now I have to use it for the first time in many years. I think the problem is that I only know basic commands. I am doing some marketing analysis and I have a small access database (but too large for Excel).

I've tried to search for the answer but I don't really know what search terms to use, so I can't find my answer. ANY help would GREATLY be appreciated.

Here are my fields: ID, Segment, Customer, Product, License, 1999$, 2000$, 2001$, 2002$, 2003$, 2004$

The database is set up so that each product can have a lot of customers and each customer can have a lot of produts, ie:

Customer Prod License
ABC, co. Car BMW
XYZ, Inc. Car FORD
ABC, co Truck <NULL>
ABC, co. Car <NULL>
XYZ, Inc. Car Ford


What I need to do is sum each of the $years and display it by Customer, then Product, then license. So if ABC, co has 3 products (Car, Truck, Boat) and 2 licenses (Ferrari, BMW) then it shouldlook like

ABC, co Car Bmw
ABC, co Car Ferrari
ABC, co Truck <null>
ABC, co Boat Ferrari


Is this even possible to do in SQL in Access? Any help would be GREATLY appreciated
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET

[socks4]

Hi, I don't know SQL too well. I taught myself a few years ago and now I have to use it for the first time in many years. I think the problem is that I only know basic commands. I am doing some marketing analysis and I have a small access database (but too large for Excel).

I've tried to search for the answer but I don't really know what search terms to use, so I can't find my answer. ANY help would GREATLY be appreciated.

Here are my fields: ID, Segment, Customer, Product, License, 1999$, 2000$, 2001$, 2002$, 2003$, 2004$

The database is set up so that each product can have a lot of customers and each customer can have a lot of produts, ie:

Customer Prod License
ABC, co. Car BMW
XYZ, Inc. Car FORD
ABC, co Truck <NULL>
ABC, co. Car <NULL>
XYZ, Inc. Car Ford


What I need to do is sum each of the $years and display it by Customer, then Product, then license. So if ABC, co has 3 products (Car, Truck, Boat) and 2 licenses (Ferrari, BMW) then it shouldlook like

ABC, co Car Bmw
ABC, co Car Ferrari
ABC, co Truck <null>
ABC, co Boat Ferrari


Is this even possible to do in SQL in Access? Any help would be GREATLY appreciated