In a query, one table w/ less rows, use the table w/ the most and have empty entries?

[offie]

I know the queries work to take data that matches up, and the table with the least rows set up the format for the query.



Is there a way to have it so that the table with the most rows shows up entirely and any parts that have no matching data in other tables shows up empty?

Example:
Table 1 has 1000 rows of data
Table 2 has 500 rows of data

I want a query that will have 1000 rows with the fields specified from 1 and 2, and the 500 rows that are not in 2 will just show up blank.

I have a query that pulls in from at least 8 tables and I started off with 20,000+ entries and now I have 702... how can I get back to the 20,000+?

Thanks!

[mdnikki]

What is the common field in both tables? Lets say there is a member ID in both
Bring in table 1 and table two and join by the member id, but change the join to #2 which is show my everything in table 1 and only those records in table 2 where the join fields are equal.

[offie]

With the tables I am using there really isn't a common field. Almost every table has a project code, but the main table that I want has repeats of the project code (each project is given a trade code ex: project 2 can be 2 A, 2 B and 2 C)

What do you mean by join? Like an append query? I am cannot alter the tables in any way since I get them from a server and do not have that permission.

[mdnikki]

Maybe this can help you with the join question. I just don't know which field you would use in each table if they don't have anything to join to begin with?
http://office.microsoft.com/en-us/ac...102749779.aspx

[mdnikki]

Can you make a copy of the table and rename it. Then do an append query to the new table created. I just don't think you can use query if there is nothing these two tables have in common.

[offie]

See it's a linked table that gets new information added every day so copying it will not allow for the new data to be added. This is why I want to do this somehow with a query or maybe some vba code or something.

They do have the project number in common but it is a one to many relationship.

Thanks!