list of times

H

Hung

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.
 
H

Hung

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.
 
D

Denis Dougall

Use a select with a where clause like secretTable.secretDate="" or
secretTable.secretDate=null

HTH
Denis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Space at end of multi page list to accommodate new entries 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Cross-reference Insert Default Change 0
(headers & footers Issue) I have 2 even pages back to back!! 1
Graph usage for times of day 0
Help please to get times of date into a graph 2
Move Chart with Text 0

Top