Code:
SELECT MONTHLYIMPORT.UID, MONTHLYIMPORT.Imprintcode, MONTHLYIMPORT.Postalcode,
MONTHLYIMPORT.Subno, MONTHLYIMPORT.Field3, MONTHLYIMPORT.Field4, MONTHLYIMPORT.Field5,
MONTHLYIMPORT.[End Date], MONTHLYIMPORT.Qty, MONTHLYIMPORT.[First Name], MONTHLYIMPORT.[Middle Name],
MONTHLYIMPORT.[Last Name], MONTHLYIMPORT.Companyname, MONTHLYIMPORT.Address1,
MONTHLYIMPORT.Address2, MONTHLYIMPORT.Address3, MONTHLYIMPORT.Address4, MONTHLYIMPORT.City,
MONTHLYIMPORT.State, MONTHLYIMPORT.Country, MONTHLYIMPORT.[Country Code], MONTHLYIMPORT.[Email Address],
MONTHLYIMPORT.[Phone Number], MONTHLYIMPORT.County, MONTHLYIMPORT.Ite, MONTHLYIMPORT.Number,
MONTHLYIMPORT.[Person Status], MONTHLYIMPORT.[Order Date], MONTHLYIMPORT.[Order Amount],
MONTHLYIMPORT.[Order Number], MONTHLYIMPORT.PriceList, MONTHLYIMPORT.PMApma_type, MONTHLYIMPORT.pma_org_name,
MONTHLYIMPORT.pma_address1, MONTHLYIMPORT.pma_address2, MONTHLYIMPORT.pma_address3, MONTHLYIMPORT.pma_address4,
MONTHLYIMPORT.pma_city, MONTHLYIMPORT.pma_state, MONTHLYIMPORT.pma_postal_code, MONTHLYIMPORT.pma_country,
MONTHLYIMPORT.Field42, MONTHLYIMPORT.[Date List Pulled] INTO july18mlFROM CBjuly18mf AS MONTHLYIMPORT
WHERE (((MONTHLYIMPORT.Imprintcode)="LF" Or (MONTHLYIMPORT.Imprintcode)="FI"));
Code:
SELECT uidsearch.UID, uidsearch.subno, uidsearch.Field3, uidsearch.Field4, uidsearch.Field5, uidsearch.[End Date], uidsearch.Qty,
uidsearch.[First Name], uidsearch.[Middle Name], uidsearch.[Last Name], uidsearch.COMPANYNAME, uidsearch.Address1, uidsearch.Address2,
uidsearch.Address3, uidsearch.Address4, uidsearch.City, uidsearch.State, uidsearch.PostalCode, uidsearch.Country, uidsearch.[Country Code],
uidsearch.IMPRINTCODE, uidsearch.Number, uidsearch.[Person Status], uidsearch.[Order Date], uidsearch.[Order Amount],
uidsearch.[Order Number], uidsearch.PriceList, uidsearch.PMApma_type, uidsearch.pma_org_name, uidsearch.pma_address1,
uidsearch.pma_address2, uidsearch.pma_address3, uidsearch.pma_address4, uidsearch.pma_city, uidsearch.pma_state,
uidsearch.pma_postal_code, uidsearch.pma_country, uidsearch.Field42
FROM july18ml AS uidsearch LEFT JOIN IMPRINT ON uidsearch.UID=[IMPRINT].[uid]
WHERE ((([IMPRINT].[uid]) Is Null));
Code:
SELECT MailCurrent.Qty, [IMPRINT].[address8], [IMPRINT].[olduid], MailCurrent.UID, MailCurrent.imprintcode, [IMPRINT].[Field15],
[IMPRINT].[Qty], [IMPRINT].[UID], [IMPRINT].[MailCurrent_subno], [IMPRINT].[Subscribers_subno], [IMPRINT].[littlepic], [IMPRINT].[address1],
[IMPRINT].[address2], [IMPRINT].[address3], [IMPRINT].[address4], [IMPRINT].[address5], [IMPRINT].[address6], [IMPRINT].[address7]
INTO julyImprint FROM july18ml AS MailCurrent, IMPRINT
WHERE ((MailCurrent.UID)=[IMPRINT].[UID]) Or ((MailCurrent.UID)=[IMPRINT].[OLDUID]);
Code:
SELECT monthimprint.MailCurrent_UID, monthimprint.imprintcode, monthimprint.Field15, monthimprint.IMPRINT_Qty,
monthimprint.IMPRINT_UID, monthimprint.littlepic, monthimprint.address1, monthimprint.address2, monthimprint.address3,
monthimprint.address4, monthimprint.address5, monthimprint.address6, monthimprint.address7
FROM julyimprint AS monthimprint
WHERE (((monthimprint.imprintcode)<>[Field15]));