Make table query creating new field?

  • Thread starter Thread starter M Shannon
  • Start date Start date
M

M Shannon

Hi,

I have a table that has a product id, the number of
pallets delivered in a week, and the revenue generated in
that week. This data is then used to find the revenue per
pallet.

I am looking at creating a make table query to add this
revenue per pallet field and have access calculate it all
for me by dividing the revenue by the pallets.

First of all is this possible?

Secondly, is the make table approach the best and easiest?
If not what would you reccommend?

Many thanks in advance.
 
Dear M:

To have your own control over the creation of a table, well, create
it. Then use an APPEND query to add data it. The results will be
much more gratifying.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top