Calculate division within Access table

T

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?
 
W

Wayne Morgan

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

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 ...
 
Top