expression for query to divide field A by field B

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

chase

Please tell me why my expression is not working now. It
worked once before. I want to divide the data in field A
by the data in field B and express the qoutient C in my
table. The query is set up in the 'Design View' as below:


(column 1) (column 2) (column 3)
field [A] [C]
table table name table name table name
update to C: [A]/

when I 'run' the query, the Access program automatically
puts the expression in quotations and updates the
records. However, it does not operate on the data. It
puts the expression itself in the column in my table.

Once I get the query to work, I want to save it to use
for all future data which will change on an ongoing basis.

My thanks to Allen Browne who said I could force the
results into the table by using an 'update query'. It
worked once, but when I tried it again, for some reason,
it will not now produce the desired results. I have
checked and rechecked the expression.

Any specific help would be apprecited.
 
Back
Top