Query formatting for numbers.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top