Grouping DB Results

[Sarah]

Hi,

I'm using ASP with an Access database to track the user's usage of a
Data Entry program. Each time the user inputs data, a record is made
in the database that includes a time and date stamp. That way I can
track how many records were made per hour, per day, etc.

My problem is in building the report page to display this
information... I'm pretty new at all of this, and I can think of a
few ways of doing it, but they all seem to require writing a lot of
code... so I'm thinking there must be an easier way to display it...

What I need is a reports page that will breakdown the data into the
day and time that entries were made... So the end result would look
something like this:

3/07/04

1:00 - 2:00
entry
entry
entry

Total Entries: 3
--------------------------
3/07/04
2:00 - 3:00
entry
entry
entry
entry
Total Entries: 4
--------------------------

Grand total: 7

Any ideas how I can best go about this?

Thanks!

-Sarah

[Bob Barrows]

Sarah wrote:

> Hi,
>
> I'm using ASP with an Access database to track the user's usage of a
> Data Entry program. Each time the user inputs data, a record is made
> in the database that includes a time and date stamp. That way I can
> track how many records were made per hour, per day, etc.
>
> My problem is in building the report page to display this
> information... I'm pretty new at all of this, and I can think of a
> few ways of doing it, but they all seem to require writing a lot of
> code... so I'm thinking there must be an easier way to display it...
>
> What I need is a reports page that will breakdown the data into the
> day and time that entries were made... So the end result would look
> something like this:
>
> 3/07/04
>
> 1:00 - 2:00
> entry
> entry
> entry
>
> Total Entries: 3
> --------------------------
> 3/07/04
> 2:00 - 3:00
> entry
> entry
> entry
> entry
> Total Entries: 4
> --------------------------
>
> Grand total: 7
>
> Any ideas how I can best go about this?
>
> Thanks!
>
> -Sarah

Is Crystal Reports an option? if so, it's the option you should use. If not,
then you will need to
order your records by the time and date they were entered and use looping
code to display them in the correct groups. Without details about your table
name, field names and datatypes, I can't get more specific than this.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"