Database Help -
08-25-2004
, 10:26 PM
I designed a simple database...to keep track of customers and their
purchases. I started by creating a table in design mode. I then
created a form by using the field list button and dragging the field
into the form. Up to this point everytrhing worked fine. If I
entered customer information in the form, the same information was
transfered to the table.
However, when I set a few of the fields in the form to do calculations
for me, (i.e. I have a tickets sold field and a and another field that
clculates the amount due based on the number entered in the "tickets
sold" field. The problem is that when I enter a number in the tickets
sold field, it does the calculation on the form, but when you go to
the table, the data does not transfer.
Any ideas? |