Update query and decimal

[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

 

[JL]

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;

 

[Anne]

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
.

.