Additon to my last post (1 Viewer)

[camaroltd82]

Also, I have a field in my database that I need to enter a formula in, like Excel. One field is cost per unit, and the other is total cost... pretty simple, but I can't figure out for the life of me how to do it.

 

[Pat Hartman]

Table columns cannot store formulas as spreadsheet cells do. Your table should store the fields - NumUnits and UnitCost. The extended cost should be calculated in the query that retrieves the data. Use queries as the recordsources for your forms and reports.

Create a query that selects the columns that you need. Then in an empty Field cell enter a name for the calculated field followed by a colon and finally followed by a calculation.

ExtendedTotal:Units * UnitCost