Alan Harrison
Registered User.
- Local time
- Today, 09:55
- Joined
- Jan 20, 2005
- Messages
- 29
I've linked my inventory database to a table that holds data for my web site. Using a macro I can transfer the data in several field at the click of a button. I've run into a problem with one field called [SizeW] in my inventory and [width] in the web site db. [sizeW]is in meters and [width] needs to be in centimeters so I made my macro expression [sizeW]*100. The trouble is I get an incorrect result. 0.87 becomes 87.0000004768372 and so on. I have tried setting the format in the web site db to General Number and 0 decimals but this doesn't work. I can't think of anything that could be the cause.
PS
Any possibility this could be caused by a naming issue? I think 'width' might be a reserved terem for access.
TAI
Alan
PS
Any possibility this could be caused by a naming issue? I think 'width' might be a reserved terem for access.
TAI
Alan