Combining two tables into a new table

[myspoonistoobig]

Hello,



So I have two tables that I'm trying to combine into a new table using values from both tables.

My first table contains export data that I pull from a program other than access. This contains customer info.

The second table contains records of checks written to these customers.

Both tables contain the field 'issue number'. I have established a relationship between the two tables using this field.

I'm trying to combine the tables so that I can see everything from my customer info table, and check numbers where applicable. Not every record in my customer info table has been assigned a check number.

When I try to run a query to bring these two tables together, it only pulls records that have been assigned a check number... I need to see everything all together.

I tried using criteria 'is null' or 'is not null' and I get the same results.

I get updated data twice a week, and will need to update this new table every time I get new data, otherwise I would just do it manually

Any help would be appreciated.

Thank you!

[June7]

Post the query SQL statement. Probably need to change INNER JOIN to LEFT or RIGHT.

This is not actually a table, it is a query.

[myspoonistoobig]

SELECT PriorityRawData.ID, PriorityRawData.Store, PriorityRawData.Service, PriorityRawData.InquiryNumber, PriorityRawData.ClosedDate, PriorityRawData.Responsible, PriorityRawData.LastName, PriorityRawData.Firstname, PriorityRawData.Address, PriorityRawData.Address2, PriorityRawData.City, PriorityRawData.State, PriorityRawData.Zip, PriorityRawData.Phone, PriorityRawData.CustomerSatisfaction, PriorityRawData.PaymentType, PriorityRawData.Status, PriorityRawData.DeclaredValue, PriorityRawData.Paid, PriorityRawData.Writeoff, PriorityRawData.AdminProcessDate, PriorityRawData.AdminNotes, CheckAssigning.CheckNumber
FROM PriorityRawData INNER JOIN CheckAssigning ON PriorityRawData.InquiryNumber = CheckAssigning.InquiryNumber
WHERE (((CheckAssigning.CheckNumber) Is Null)) OR (((CheckAssigning.CheckNumber) Is Not Null));

[June7]

Yep, suggest you change to LEFT or RIGHT, probably RIGHT if you want to show all InquiryNumber even if there is no associated check, then remove the filter criteria.

[myspoonistoobig]

This absolutely solved my problem.

THANK YOU