Calculate division within Access table

[tallulah]

I'd like to show an sales average (in a third column)
between Total # Sales & Gross Sales. I'm sure you'd have
to have the two columns next to each other, but can it be
done?

 

[Wayne Morgan]

Calculations can't be done in a table. This could be done in a query or a
textbox on a form.

 

[Van T. Dinh]

NOT in Table!

You don't want to store redundant or calculated values in Table as these
violates the Relational Database Design Principles.

Generally, these calculation should be done in Queries / Forms / Reports /
VBA code ...