Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access: Selecting which Field to populate based on contents of another

Status
Not open for further replies.

urielsmemory

Technical User
Jun 6, 2007
3
US
Greetings,
I am building a forecasting tool and due to the input restrictions imposed by the users have the following problem.

I have a table (tblA) with the fields: ProductID, Qty shipped, Ship date. (Example row: 1, 50, Jul07)

I have another table (tblB) which contains information on the same product, but with the following fields: Product ID, Jun07, Jul07, etc (Example Row: 1, 5, 10, etc).

I need to write a query that draws of both these tables and aggregates. I would like to build table C, with fields: Product ID, sumJun07, sumJul07, etc. (Example Row: 1, 5, 60, etc)

I am not very familiar with SQL or VBA. Is there a way to make access do this without customer writing something? If not, is there a quick clean piece of code that could help me do what I need to?

WJW
 
You might get better/faster answers here:

forum701

< M!ke >
Acupuncture: a jab well done.
 
When you do post in the correct forum, you'll probably get the question of why you're keeping "Qty Shipped" values in two different tables. When you post your question, show your tables and fields. Right now they don't seem to be Normalized. No normalized tables, no Access database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top