Table Relationships for a Newbie!

[zmbd]

Sorry, I should have added the following link in my prior post too: Before Posting (VBA or SQL) Code

Of importance at this point is the first section "A"
By following the directions there, you will help to avoid some of the compile errors at run-time... such as the one you just encountered.

[TheSmileyCoder]

Thats lovely to hear. Its alot easier to work with people(like you) who can properly explain their question, and provide relevant details.

[dgaletar]

I couldn't have done it without your help TheSmileyCoder! Thank you.

Now, are you any good with "Aggregate Queries"? NeoPa is driving me nuts with his advanced way of instructing! I know he's trying, but he just doesn't get me.

Here's the thread: http://bytes.com/topic/access/answer...-our-inventory

If not, it's OK. I'll eventually figure it out. :)

[zmbd]

dgaletar:

You might look at cross tab query; however, you will need to start a new thread for that question. Both Rabbit and TheSmileyCoder are magicians with the SQL!

You might also take a look at my reply in the thread you note in post #18.

[dgaletar]

I found it! http://www.worldbestlearningcenter.c...e-function.htm worked perfectly! Thanks Bytes forum people. Hope to be back real soon!!!