Calculate division within Access table

  • Thread starter Thread starter tallulah
  • Start date Start date
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?
 
Calculations can't be done in a table. This could be done in a query or a
textbox on a form.
 
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 ...
 
You use a query. The results will look and work like a table, but will
not take up any storage space.

Create a query based on the table. Add the two fields you want to use
and then in design mode create a new field. Let's call it AverageSales. On
the name line type in this:

AverageSales: [Gross Sales]/[Total # Sales]

That's all there is to it.

Good Luck
 
Back
Top