I'm self taught and my teacher is an idiot! VERY basic query question

[ColinVicary]

Hi everyone.



This is my first post so please go easy on me! I'm intermediate/expert at Excel, but a novice in Access, creating my first DB today.

I have two tables, one is a stock catalogue with SKU as a primary key. The other is orders received last week, which also contains SKU. The two SKU fields are linked in relationships.

If I run a simple query on the orders, to show all the SKUs with an order qty, grouped and summed, the query works fine. Within the order table, the item name can differ for the same SKU (we sell on Amazon in the UK and USA and the terminology and spelling can be different). So I bring in the item name from the catalogue table. My query shows:-

SKU from the order table of 600 lines
Item Name from the to catalogue table of 1,600 lines
Quantity Ordered from the order table

now my query result seems to show the first SKU, with EACH Item Name, then the second SKU, with EACH item name.

I guess what I'm looking for is a link to a site that will show me how to do the basics. The sites I've found and followed online haven'ts helped so far!

Anything you can do to help would be appreciated!

Colin

[orange]

I recommend you watch these free videos (#1,2 and 4) by Dr Daniel Soper.
He has a 8 part series starting here.

Another suggestion is to work through this tutorial from RogersAccessLibrary. It will teach you database design concepts and a procedure to define tables and relationships. Takes about 1/2 hour -45 minutes to work through but you will learn. There is a problem definition and solution providing a database design that matches the requirements. You can use what you learn with any database.

[ColinVicary]

Thanks orange, I'll check those out right now

Colin

[John_G]

In your query design view, did you link the tables on the SKU field? The results you are getting suggest you didn't. Even though you created the relationships, you have to join the tables in queries as well.

[redbull]

If your teacher is teaching you Access VBA. I promise you he visits this website.