Question about how to take 2 values from 2 tables on the same day and * them

[LCG4LIFE]

I have 2 tables set up. The first has 4 fields ID, Date, Quantity1, Quantity2, Quantity3. The Second has ID, Date, Price1, Price2, Price3.

I'm looking for a way to have quantity multiple price on the same day.

Example:

Table 1
ID:1
Date:3/14/2011


Quantity 1:300

Table 2:
ID:1
Date:3/14/2011
Price 1: $3.50

How I'd like this to work is for a query or something to take from table 1 on 3/14/2011 300 and multiply it be table 2's 3/14/2011 price of $3.50.

I've only been using access for several days so I'm green. If anyone can help and keep it simple that would be appreciated.

[NoellaG]

Hi,

first I would look at your database design, if you have a table with fields like quantity1, quantity2, ... you aren't even in first normal form, so you're bound to get into trouble.
Normalize your database design and all will be much easier.
There are a lot of sites where you get tips how to design your database like http://www.databasedev.co.uk/databas...on_basics.html.


gr
NG