Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
If I understand ETA correctly, it means Estimated Time to Arrival. How do you have a non-NULL ETA value and also a NULL delivery date?
| | | ---------------Original Message---------------
From: Hikerdood
Sent: Saturday, March 12, 2011 3:39 PM
Subject: Access Date Function Unoin Query
We import from 17 different vendors and in order to give our receiving department a heads up as to what is coming in we have created a template for each vendor listing [Order #], [Style], [Number of Cartons], [ETA] and [Delivery Date to Warehouse]. They fill in the required info as it relates to everything but Delivery Date to Warehouse. Once we receive notification from the trucker about the delivery date we fill that in. I created one Union Query for all 17 files and pull all of those records WHERE: [ETA] IS NOT NULL . I need to pull those records that have an ETA, but a null delivery date and also those that have a delivery date. I also need to keep at least 2 days worth of receiving history to pull from this union query so that receiving can see what came in 2 weekdays ago. The results would then be exported via an excel file to a certain directory, subtotaled for viewing by receiving. How do I write the statement to pull null values, 2 weekdays back, current
date and future date for the [Delivery to Date to Warehouse] field. The ETA statement is no problem.
Any help would be appreciated. Thank you
Gene |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Most Popular White Papers
In the Spotlight  _.____.__ |
