W
Weste
I have a client that wants their data entry form to have the look and feel of
Excel. The basic format they want is below.
Units Dollars
Project ID Rate Jan Feb Mar Jan Feb Mar
56 10 5 7 15 50 70
150
The units are actually stored in the table by week ending date vs. month.
After the monthly units are entered by a user, they would be converted to
weekly units and then saved to the database. As a result, in order to get
the monthly view, a crosstab query must be used. The dollars are calculated
by multiplying the units by the rate. My initial response was this cannot be
done. I know Access has a data grid control in the toolbox, however, I have
been unable to locate any good documentation on this control. Can this
design be accomplished using Access? Thanks for your help.
Weste
Excel. The basic format they want is below.
Units Dollars
Project ID Rate Jan Feb Mar Jan Feb Mar
56 10 5 7 15 50 70
150
The units are actually stored in the table by week ending date vs. month.
After the monthly units are entered by a user, they would be converted to
weekly units and then saved to the database. As a result, in order to get
the monthly view, a crosstab query must be used. The dollars are calculated
by multiplying the units by the rate. My initial response was this cannot be
done. I know Access has a data grid control in the toolbox, however, I have
been unable to locate any good documentation on this control. Can this
design be accomplished using Access? Thanks for your help.
Weste