list of times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which has a list of times, in 15 minute increments, and the
number of calls received by a call center for each interval. The reporting
database removes times where there were no calls. I want to add the times
and zeros back in.

Can anyone offer any advice, please.
 
Sorry, report was the wrong word to use, there are standard reports in our
reporting program but they do not include the empty 15 minute intervals. I
was given permission to use the database in access to create a custom report
that included these values, to my surprise...the database actually removes
these time periods as well.

So, to make a long story short...I do not yet have a report, that is what I
need help creating.
 
Use a select with a where clause like secretTable.secretDate="" or
secretTable.secretDate=null

HTH
Denis
 
Back
Top