Letter in order Numbers

[Simon]

I store Order number as 0001, 0002 ect but when i print them out on
reports i put WSOR infront eg WSOR0001

If have a customer that phones up and i have to earch for the order i
have to just type in 00001 in the field to search. Some times i type in
WSOR0001 is there a way if i type it all in to set it up to ignore the
WSOR part and just take the number


Thanks

 

[Joseph Meehan]

I store Order number as 0001, 0002 ect but when i print them out on
reports i put WSOR infront eg WSOR0001

If have a customer that phones up and i have to earch for the order i
have to just type in 00001 in the field to search. Some times i type
in WSOR0001 is there a way if i type it all in to set it up to ignore
the WSOR part and just take the number


Thanks

If it is always four characters (the last four) you can use the Trim
function.

 

[Simon]

how do i do trip funtions

I have never used them before

 

[Joseph Meehan]

how do i do trip funtions

I think I may have mislead you. In any case this is from the help file:

Right([ShipPostalCode], 5)
Truncates the leftmost characters, leaving the five rightmost characters

You would want to use your field name to replace the "ShipPostalCode"
and "4" rather than 5. The result of that expression, which you can use in a
report, query or form, would be the 0001 or 0002 etc. that you are
interested in.