Criteria on my second table does not appears when i run two joined tables.

[armrodnun]

Why the criteria on my second table does not appears when i run two joined tables in Access?

I joined two tables and when I run it, only the criteria on my first table appears, but not from the second one. what did i do wrong?

I have attached the file to my thread. The query named is "joined". can someone please help me! I am new with Access! thanx!

I did add the specific field from that second table to my query, but only the fields appears from my second table with no data.

 

[SOS]

Your problem is that you have linked two unrelated fields. You need the link to be between the two AdRepNumber fields instead.

 

[Scooterbug]

A couple of things...

First, it's a good idea to use an autonumber for a Primary key. As Primary Keys should be unique, this is the best way to gaurentee that it remains unique. Second, it's never a good idea to use spaces in your field names. It can cause confusion when writing code. Third, your query didn't work because you were joining two fields that had no relation to one another. You dont base a join on both tables Primary key. The relationship is based on a Primary key/Foreign Key.

In the query design view, remove the join by right clicking and deleting it. Click and hold on the field "Ad Rep Number" from Ad Rep and drag it over to "Ad Rep Number" from Advertiser. You are also going to need to go and fix the same thing in the Relationship Window.

I would suggest that you read a few tutorials on database design before going ahead with a project. It will save you plenty of heartache in the future.