J
Jane Schuster
I have a table that contains ClientId and ScheduledDueDate (each Client must
submit a plan within 2 days on either side of the ScheduledDueDate), this
table contains various dates for each client 14 days apart, some schedules
are just 6 months long, others are as long as 2 years). Another table tracks
when the plans are actually received (ClientId, SubmittedDate, etc). The
only common field is ClientID. I can't set up the Unmatched Query Wizard to
get the results I'm looking for. How can I write a query to determine if the
plans submitted are within (or not within) 2 days on either side of a, or
any, scheduled date?
For Example:
tblClientSchedule
Client ID ScheduledDueDate
111 06/30/08
111 07/14/08
111 07/28/08
111 08/11/08
tblClientPlans
ClientID SubmittedDate Plant
111 7/01/08 Buy Yankees (good, met schedule)
111 7/12/08 Sell Yankees (good, met schedule)
111 8/04/08 Get a Job (not good, outside
deadline)
Any help would be very much appreciated.
submit a plan within 2 days on either side of the ScheduledDueDate), this
table contains various dates for each client 14 days apart, some schedules
are just 6 months long, others are as long as 2 years). Another table tracks
when the plans are actually received (ClientId, SubmittedDate, etc). The
only common field is ClientID. I can't set up the Unmatched Query Wizard to
get the results I'm looking for. How can I write a query to determine if the
plans submitted are within (or not within) 2 days on either side of a, or
any, scheduled date?
For Example:
tblClientSchedule
Client ID ScheduledDueDate
111 06/30/08
111 07/14/08
111 07/28/08
111 08/11/08
tblClientPlans
ClientID SubmittedDate Plant
111 7/01/08 Buy Yankees (good, met schedule)
111 7/12/08 Sell Yankees (good, met schedule)
111 8/04/08 Get a Job (not good, outside
deadline)
Any help would be very much appreciated.