Search results

reply I need to retrieve the records from fields four,five and six as well as the other fields. This is about retrieving records that are already in my 2 tables that have field headings.

I have two tables that have related fields in them. I would like to query these two tables to get all the data that the fields are the same. If you look at the attached file, I would like to enter criteria for fields one,two and three from both tables, and have fields four five and six come back...

follow up How do I create a Union query?

I attached two files of the tables I am trying to query data from. Can someone help me to join these tables and pull data that will look at both tables, not just one. For example: I would like to create a query that pulls all job numbers for a certain week # Thanks, Steve

I have not mastered how to join tables with relationships yet. Can someone help me? I have two different tables that hold some of the same types of information. There are alot of the same catagories in both tables. But all the data is unique. I think that I need a primary keys but not sure. I...