Query formatting for numbers.

[Guest]

I have an application in which I download data from another Access db. On
one append query I format the number field using:
format(Piece.Width,"0.000"). On the other append queries this works great.
All of the fields that I'm appending into are single for the data type with 3
decimal places.

On the on that fails my client gets an error message on the download:"3075
Function is not available in expressions in query expression
'Format(Piece.Width,"0.000"). I myself cannot recreate this on my own machine.

TIA
-Craig

 

[Guest]

Check this post on a similar issue

http://www.microsoft.com/office/com...ries&mid=4cc6526a-83dc-4566-a9b8-dcaa416d4e0c

 

[Douglas J. Steele]

If the query is running from outside of Access, there are very few VBA
functions that you can use in the query. Unfortunately, there's no way
around this: the Jet Engine simply doesn't know about the functions.