J
Jjona
I am converting my .mdb form to .adp (both in Access
2000). I have an "orders" table and an "order details"
table that are placed on a form(i.e. "order details" acts
as the subform). I need to calculate the order total and
place it on the main form(i.e. extract data from the
subform and place a calulated result in the main form in
a field). I have created a stored procedure to make the
calculation, but I can't seem to place it in a field on
the form. Can someon tell me if it is a stored procedure
that I need to use or should I attempt to use ADO to make
this calulation? Incidentally, I need this to update upon
every entry in the sub form.
Many thanks in adavance,
Jjona
2000). I have an "orders" table and an "order details"
table that are placed on a form(i.e. "order details" acts
as the subform). I need to calculate the order total and
place it on the main form(i.e. extract data from the
subform and place a calulated result in the main form in
a field). I have created a stored procedure to make the
calculation, but I can't seem to place it in a field on
the form. Can someon tell me if it is a stored procedure
that I need to use or should I attempt to use ADO to make
this calulation? Incidentally, I need this to update upon
every entry in the sub form.
Many thanks in adavance,
Jjona