DATA ENTRY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Murren - 05 Jan 2004 16:52 GMT

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

Reply to this Message

Tim Ferguson - 05 Jan 2004 18:23 GMT

> 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

Reply to this Message