Update query and decimal

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

My table has a field with two decimal places. I cannot
get update query to increment the decimal.

I update to [2decimalfield]+ 0.01 and nothing happens.
Does anyone know what I am doing wrong?

Thanks,
Anne
 
I have tested to see if it will work.
I have no problem update a field ([somedecimalfield] +
0.01).
This is my update query looks like. Table1.NUM is defined
as Double.

UPDATE Table1 SET Table1.NUM = [Table1].[NUM]+0.01;
 
Its always the simple things. Double! I had long
integer.

Thank you so very much for your response. Problem solved.
Anne

-----Original Message-----
I have tested to see if it will work.
I have no problem update a field ([somedecimalfield] +
0.01).
This is my update query looks like. Table1.NUM is defined
as Double.

UPDATE Table1 SET Table1.NUM = [Table1].[NUM]+0.01;
-----Original Message-----
My table has a field with two decimal places. I cannot
get update query to increment the decimal.

I update to [2decimalfield]+ 0.01 and nothing happens.
Does anyone know what I am doing wrong?

Thanks,
Anne
.
Click to expand...
.
Click to expand...
 
Back
Top