V
Vincent DeLuca
Hello-
What is the best way to create a totals datagrid? A
little background--we have a database in which we enter
warehouse pulls for each employee every night. Each
Employee pulls for one company at a time. A record is one
employee pulling for one company on one shift. Each
employee will have various records each day.
We need to total the total pulls for an employee for each
day. We need a form that lists one row per employee and
shows the total pulls for each day for one week on one
line, and the next employee and his/her pulls on the next
line, and so on like a spreadsheet. So each value will be
an aggregate sum of all the pulls by that employee for
that specific day of that specific week. My thought was
to create an array for all the pulls for the week as a
dataset. From this dataset, I thought I would create a
list of the employees that pulled that week, and from that
sorted list (by employee name), create an array for each
employee for each day of the week.
Assuming these are the best ways to proceed, I still need
help in the best way to do these many aggregate sums
(seven per employee, there are about 20 employees at this
time for about 140 aggregates in a week). I also need
some input as to the best technology to use for Access97
opening techniques for data access, dataset reads and
writes. I am new to Access programming, but have
considerable programming experience in other platforms.
This application is being developed in Access 97. Would I
use ODBC, ActiveX or some other technology to best
effect? Thank you.
Vincent DeLuca
(e-mail address removed)
What is the best way to create a totals datagrid? A
little background--we have a database in which we enter
warehouse pulls for each employee every night. Each
Employee pulls for one company at a time. A record is one
employee pulling for one company on one shift. Each
employee will have various records each day.
We need to total the total pulls for an employee for each
day. We need a form that lists one row per employee and
shows the total pulls for each day for one week on one
line, and the next employee and his/her pulls on the next
line, and so on like a spreadsheet. So each value will be
an aggregate sum of all the pulls by that employee for
that specific day of that specific week. My thought was
to create an array for all the pulls for the week as a
dataset. From this dataset, I thought I would create a
list of the employees that pulled that week, and from that
sorted list (by employee name), create an array for each
employee for each day of the week.
Assuming these are the best ways to proceed, I still need
help in the best way to do these many aggregate sums
(seven per employee, there are about 20 employees at this
time for about 140 aggregates in a week). I also need
some input as to the best technology to use for Access97
opening techniques for data access, dataset reads and
writes. I am new to Access programming, but have
considerable programming experience in other platforms.
This application is being developed in Access 97. Would I
use ODBC, ActiveX or some other technology to best
effect? Thank you.
Vincent DeLuca
(e-mail address removed)