need another alternative for query

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

I'm very new with access so I need basic information on
how to create a month end report. Based on a 5 day work
week, we receive cases each day. These caases are logged
with date received and date resolved. If the case comes in
on Monday, Tuesday or Wednesday, the goal turnaround time
used in my calculation is 2, however if the case is
received on Thursday or Friday, the turnaround time used
in my calculatin will be 4 to accomodate the weekend. I
also need to think ahead for weeks that have holidays and
I have to accomodate for those. What I would like, and I
know this is not the best or easiest way to generate this
report, but I would like a query that looks at each date
and assigns the correct turnaround time. I realize that
each month I'll have to change the dates in the query, but
since this report is generated once a month, the maintence
is minor. How would I stipulate a query that looks at
each case received on a specific date and then assign the
correct turnaround time. The report is a date range
report and the user imputs the start and end date. Thank
you
 
What you're going to need to do is call a VBA function that does the
calculation for you and returns the correct TurnAround. You can use the
DatePart command to pull out the day of the week, and even (if you're
feeling ambitious <g>), check a table of holidays so that you don't need to
fiddle with it each month.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top