I am using DBAccess 2007. I have a database called Table with many fields. I am trying to get a report that shows "Profit" (not defined as a field in the table). This will be two different totals as the first will be Units on Hand X Original Price and the second is Units on Hand X Sales prices to get a Profit. We are only in the reporting section of the class and I have been told
You have to group your data first, then you can add text fields for the profit and other calculated fields

I have tried this and it does not work or am not doing it right. Please help!!

Thanks,

Try creating a query, select the fields that live in your table, then write a formula like in Excel to get the profit.

Also I bet if your table is really named Table that's confusing the database.