Access Reports

[texasman]

Since this is the first time I have created an Access database I'm sur
this is a stupid question but here goes....I have created two differen
tables. One with Customer information in it and the other with Produc
information in it. I'd like to be able to create a report based on
different queries (one that asks for the customer name and the next as
for the product id). Is it possible to create this report without an
fields being linked between the two tables. I'm using Access 200
(just ordered 2003). Any help is greatly appreciated

 

[Michael R Mattys]

Texasman,

It's possible that you haven't expressed what you are
actually trying to do. If it were my database, I would
set it up so that I had Orders and Order Details tables
so that I could relate the customer to a particular order
that listed the products for that order.

Then I could create reports that show what products a
customer has ordered, how many, during what time period,
etc, etc ...

--

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com

 

[texasman]

Ok I have two tables:
Customers (with the following fields):
Customer Name
Attn:
Address
City
State
Zip

Heat Data (with the following fields):
Heat Number
Lot Number
Diameter
Wall
Flatten
Hydro
C
MN
PH
Su
S
CU
N
CR
MO
VA
Yield
Tensile
Elong %

All I want is to be able to do is print a report that has the customers
name and the heat information. What they would do ideally is query for
the customer (would be nice to have a drop down to find the customer)
then they would choose the heat number (there are 12,000 different
heats). Based on the information given from the query I would like to
create a report that prints out the chemical analysis in those fields
under the heat table. Is this possible???