DATA ENTRY

[Frank Murren]

I have a table linked to a SAGE accounting system thru an ODBC link.
As part of the data entry process, I need to input a Sales Order
Number on a form which is of the format ... 0000012345.
Is there any way that I can only enter 12345 on the form, but when the
data is transferred onto the underlying query/table it then
automatically adds on the 5 leading zero's.
Thanks for any help which is offered

 

[Tim Ferguson]

(e-mail address removed) (Frank Murren) wrote in

Number on a form which is of the format ... 0000012345.
Is there any way that I can only enter 12345 on the form,

SELECT ...,
FORMAT(SONumber, "0000000000") AS FSONumber,
...


or the equivalent in the query grid:

FSONumber: FORMAT(SONumber, "0000000000")

Hope that helps


Tim F