Seagate Info

ninners · Dec 11, 2003

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

synapsevampire · Dec 12, 2003

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

ninners · Dec 16, 2003

Thanks for the reply. That seems like the best way to resolve this.
ninners

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!

Seagate Info

ninners

Programmer

synapsevampire

Programmer

ninners

Programmer

Similar threads

Part and Inventory Search

Sponsor