Calling on any Microsoft 97 Access experts...are you there?

[Robert]

Although it's a bit more complex than this here's basically my problem:

After creating a database table [i.e., Table1] with 3 fields named, "Qty"; "Cost/item" and "Total" I made a form to enter info back into this "Table1" database.

All I want to do is simply open the form and take Qty x Cost/item to get a total cost. So I opened up "expression builder" in the "Total" field and entered "=[Qty]*[Cost/item]"

Okay, once I am out of "form design" and plug in some numbers...like 4 x $2.00/item... the "Total" field displays $8.00. But after I press the "Add record" command button the only info that is added to the "Table1" database is the "Qty" [4] and Cost/item [$2.00]! The "Total" cost field remains empty. Why...what am I doing wrong?

Rob

[Clio]

You have to bind the field on your form that receives the calculated total to the field in your database so the result is saved.

Start there. It's been too long for my Access brain... but that's your starting point.

[Robert]

The form is bound to the expression "=[Qty]*[Cost/item]"