Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Seagate Info

Status
Not open for further replies.

ninners

Programmer
Apr 22, 2003
10
US
Trying to write a report here and I hit a bit of a snag. I'm trying to create a report that shows incoming calls grouped by half hour for each day. Right now its only showing half hours where calls came in. I'm looking for a way to display every half hour. Even the ones where there is no calls.

Is there a way to display each half hour even if there is not a record for that half hour?

Thanks so much for ANY help,
ninners
 
Age old question here, and my pat answer is to create a table which contains every half hour, and LO join your data to it.

-k
 
Thanks for the reply. That seems like the best way to resolve this.
ninners
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top