Jan 20 2006, 11:02 AM
I currently have a number field in a form that is called amount due. I would like to link a field to this amount that will spell out the number. For example the amount field has a value of 35 in it. I would like the linked field to say "thirty five". I can't seem to get anything to work. I can either do this in a query or I can do it in the form. Thanks in advance for all the help.
Jan 20 2006, 11:05 AM
Jan 20 2006, 11:26 AM
Thanks, this works perfectly. Secondly, is there a way in a query to return the value of a number after the decimal places. For example 35.23 and return just 23 or 1281.96 and return 96.
Jan 20 2006, 11:31 AM
try a combination of the mid and instr function or the right function since the dot would always be on the third position from the right:
Jan 20 2006, 11:32 AM
Jan 20 2006, 11:34 AM
Glad I could assist.
Good luck on future projects!
Jan 20 2006, 12:26 PM
would work too providing the intial number always has 2 digits after the dp.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here