Hi dear Forum! This my first post, so bear with me for any mistakes I make or conventions I do not observe (unintentionally, of course )

I would like to achieve the following:

I have an Inventory of mobile phones (ca. 15000 entries), which is stored as a table in Access and contains information like Number, First Name, Last Name, Email, Tariff, Contract Start Date/End Dates.

I receive weekly a table with a summary of orders (ca. 20 per week), which include: changes to User Details, Tariffs, Contract Start/Ending Dates and new orders.

Now I would have to have to updates: one to add the new numbers as rows, and one to update the relevant fields for the existing numbers.

I have created two queries:

One two add the new numbers:

INSERT INTO InventoryReportRaw ( [Mobile Number], Tariff, [Cost Centre], [Contract end date], [Activation date], [First Name], [Last Name], Email )
SELECT OrderReport.EndUserNr, OrderReport.Tariff, OrderReport.CostCentre, OrderReport.ContractEndDate, OrderReport.FutureActivationDate, OrderReport.EndUserFirstName, OrderReport.EndUserLastName, OrderReport.EndUserEmail
FROM OrderReport, InventoryReportRaw
WHERE (((OrderReport.TransactionType)="Change-BAN") AND ((OrderReport.Status)="Completed")) OR (((OrderReport.TransactionType)="CTN-PortingIn") AND ((OrderReport.Status)="Completed")) OR (((OrderReport.TransactionType)="CTN-TransferIn") AND ((OrderReport.Status)="Completed")) OR (((OrderReport.TransactionType)="Svc-Delivery") AND ((OrderReport.Status)="Completed"));

And one to update existing fields:

UPDATE OrderReport RIGHT JOIN InventoryReportRaw ON OrderReport.EndUserNr = InventoryReportRaw.[Mobile Number] SET InventoryReportRaw.[Last Name] = [OrderReport].[EndUserLastName], InventoryReportRaw.[First Name] = [OrderReport].[EndUserFirstName], InventoryReportRaw.Email = [OrderReport].[EndUserEmail], InventoryReportRaw.Tariff = [OrderReport].[Tariff], InventoryReportRaw.[Contract end date] = [OrderReport].[closure date], InventoryReportRaw.[Contract end date] = [OrderReport].[closure date]
WHERE (((OrderReport.TransactionType)="Svc-chg-details" Or (OrderReport.TransactionType)="Svc-chg-details" Or (OrderReport.TransactionType)="Svc-chg-details" Or (OrderReport.TransactionType)="Svc-Chg-Tariff" Or (OrderReport.TransactionType)="Terminate-Nr" Or (OrderReport.TransactionType)="CTN-TransferOut") AND ((OrderReport.Status)="Completed"));

When I run the queries, Access tells me it is going to Append/Update over 100000 records - which just cannot be true.

Do you have any suggestions as to how I can solve my problem? I am open to any tips!

Thanks in advance,

werderexpat