R
Rod
This one has me stumped. I figured a query is needed to create a single
report which I need to look like the following:
Called On 1stInterviews MsgsLeft ApptSet MTDHires
MTDProdQTYSold
Mon, Mar 19 07 4 13 6 5
2715
1) tblCANDIDATES is the table name
2) Called On is stored as date in CALLED_ON.
3) 1stInterviews is the total of BOOKED on CALLED_ON
4) MsgsLeft is the total MESSAGES on CALLED_ON
5) ApptSet is stored in an Outlook calendar. I need to find ":" in the
subject field of all appointments over the next 7 days (including the current
day). I was thinking a link to this would work be I did not see a Start Date
field in the linked table to Outlook. If I find ":" then the calendar event
is an appointment and can be added to the total if the appointment date is
w/in the 7d window.
6) MTDHires comes from finding IBA_DATE is not null and is within the
current month
7) Current month is found in tblMonths with structure (of type short date):
Month StartDate EndDate
8) MTDProdQTYSold is found in tblDBlast. I am using PREM_AMT to store the
qty and PREM_DATE to store the date it was sold. So the PREM_DATE would have
to be in the current Month-to-Date range in order to be able to add PREM_AMT
to the total.
I realize this is a challenge. I appreciate your help!
report which I need to look like the following:
Called On 1stInterviews MsgsLeft ApptSet MTDHires
MTDProdQTYSold
Mon, Mar 19 07 4 13 6 5
2715
1) tblCANDIDATES is the table name
2) Called On is stored as date in CALLED_ON.
3) 1stInterviews is the total of BOOKED on CALLED_ON
4) MsgsLeft is the total MESSAGES on CALLED_ON
5) ApptSet is stored in an Outlook calendar. I need to find ":" in the
subject field of all appointments over the next 7 days (including the current
day). I was thinking a link to this would work be I did not see a Start Date
field in the linked table to Outlook. If I find ":" then the calendar event
is an appointment and can be added to the total if the appointment date is
w/in the 7d window.
6) MTDHires comes from finding IBA_DATE is not null and is within the
current month
7) Current month is found in tblMonths with structure (of type short date):
Month StartDate EndDate
8) MTDProdQTYSold is found in tblDBlast. I am using PREM_AMT to store the
qty and PREM_DATE to store the date it was sold. So the PREM_DATE would have
to be in the current Month-to-Date range in order to be able to add PREM_AMT
to the total.
I realize this is a challenge. I appreciate your help!