query for a division calculation

  • Thread starter Thread starter chase
  • Start date Start date
C

chase

My objective is to set up a query for a qoutient to
appear in a 3rd column (C). The information that is in
my data base is in column A and in column B. The query
that I have set up is as follows: C: [A]/. The
following information is the exact screen as it appears
in the query.

(1st column] (2nd column) (3rd column)
field C: [A]/ [A]
file name file name

The file name is automatically done by the Access
program.

After I close and save the query and go to the table,
there is no data in the 3rd column C. What am I doing
wrong.

Any help would be appreciated.
 
A basic query will only show you the results of calculations. It does not
actually modify the data in the table. If you wanted to actually write the
results of this calculation into the table you will need to make your query
an Update query.

Kelvin
 
Back
Top