Query formatting for numbers.

C

Craig

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
Access 2K2: making numbers up in a query sum 1
How do I get Access to append the exact amount with decimals? 2
query field names changing to expr#: 8
Appending null data and moving! 4
Decimal places question 6
Access 2010 DB not fuctional with multiple users 2

Top