DATA ENTRY

  • Thread starter Thread starter Frank Murren
  • Start date Start date
F

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
 
(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,
Click to expand...

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


or the equivalent in the query grid:

FSONumber: FORMAT(SONumber, "0000000000")

Hope that helps


Tim F
 
Back
Top