RogerCooper
Registered User.
- Local time
- Today, 12:39
- Joined
- Jul 30, 2014
- Messages
- 746
I have a simple SQL query that is e-mailed when there are >0 records. Fairly consistently, the SQL code in the query is wiped out and the query fails. It happens consistently to this query, even though I have many similar queries. Does anyone have an idea about what is happening. I am running Access 2013 in Windows 7
SELECT AR.[Inv#], [History Header].[PO#], AR.[Customer Name], AR.Date, AR.Mdse, AR.Freight, AR.Amount, AR.[Due Date]
FROM (AR INNER JOIN [History Header] ON AR.[Inv#] = [History Header].[Inv#(number)]) LEFT JOIN [Advanced Engineering Payment Reminder Sic] ON [History Header].[Inv#(text)] = [Advanced Engineering Payment Reminder Sic].ID
WHERE (((AR.[Customer Name])="ADVANCED ENGINEERING") AND ((AR.Amount)>0) AND ((AR.[Due Date])<=Date()) AND (([Advanced Engineering Payment Reminder Sic].ID) Is Null))
ORDER BY AR.[Inv#];
SELECT AR.[Inv#], [History Header].[PO#], AR.[Customer Name], AR.Date, AR.Mdse, AR.Freight, AR.Amount, AR.[Due Date]
FROM (AR INNER JOIN [History Header] ON AR.[Inv#] = [History Header].[Inv#(number)]) LEFT JOIN [Advanced Engineering Payment Reminder Sic] ON [History Header].[Inv#(text)] = [Advanced Engineering Payment Reminder Sic].ID
WHERE (((AR.[Customer Name])="ADVANCED ENGINEERING") AND ((AR.Amount)>0) AND ((AR.[Due Date])<=Date()) AND (([Advanced Engineering Payment Reminder Sic].ID) Is Null))
ORDER BY AR.[Inv#];
