BennyLinton
Registered User.
- Local time
- Today, 09:36
- Joined
- Feb 21, 2014
- Messages
- 263
I have a parameterized update query that is supposed to write in a user provided TackingNumber as long as no Tracking number exists for some records to be updated. However no rows are updated. I have the field set as simpleDate. Ideas
UPDATE Applicants SET Applicants.TrackingNumber = [Enter Tacking Number]
WHERE Applicants.[DateEmailedPrinter] = [Enter Date Sent To Printer]
AND Applicants.TrackingNumber is null;