A
Anna
Hi,
I would be grateful for any help:
I have a form bound to a table and have recently added two
fields to the table - one that calculates a number based
on OrderDate, and another that creates an "Order ID" no by
adding this to a customer ID field.
I have got a query to add these fields retrospectively,
but how can I get the form to calculate them(and put the
data in the table) as I enter the data in the form?
Many thanks,
Anna
I would be grateful for any help:
I have a form bound to a table and have recently added two
fields to the table - one that calculates a number based
on OrderDate, and another that creates an "Order ID" no by
adding this to a customer ID field.
I have got a query to add these fields retrospectively,
but how can I get the form to calculate them(and put the
data in the table) as I enter the data in the form?
Many thanks,
Anna