H
hughess7
Hi all
I have two tables:
[QuarterlyPlanner]
SpecID
ReviewDate
Activity
DealerCode
etc
[PlanDates]
SpecID
ReviewDate
ReviewDates
They are linked one to many, in QuarterlyPlanner ReviewDate is the Start
Date of an activity. If the activity lasts for more then one day than the
extra dates are stored in PlanDates (ReviewDates). This is a new procedure
for my system, I have had to do it as some new employees can now be working
over weekends (poor them!! ).
My question is how do I join the two tables together to produce a plan
(report)? I know I can do a union query to produce just a list of all dates
from the two tables but I am not sure how to include the extra fields
(activity, dealercode etc). I want each day on the plan to have this data
showing.
Can I do this with some queries or do I need to do it in code and write to a
temporary table?
Hope this is clear! Thanks in advance for any help.
Sue
I have two tables:
[QuarterlyPlanner]
SpecID
ReviewDate
Activity
DealerCode
etc
[PlanDates]
SpecID
ReviewDate
ReviewDates
They are linked one to many, in QuarterlyPlanner ReviewDate is the Start
Date of an activity. If the activity lasts for more then one day than the
extra dates are stored in PlanDates (ReviewDates). This is a new procedure
for my system, I have had to do it as some new employees can now be working
over weekends (poor them!! ).
My question is how do I join the two tables together to produce a plan
(report)? I know I can do a union query to produce just a list of all dates
from the two tables but I am not sure how to include the extra fields
(activity, dealercode etc). I want each day on the plan to have this data
showing.
Can I do this with some queries or do I need to do it in code and write to a
temporary table?
Hope this is clear! Thanks in advance for any help.
Sue