Custom Numbers & Append Query

[Safari]

Hi All

How Can I Solve My Problem ...

When I Append A Record With Custom Number + Letter To Anther Table I Found Only Number .. For Example :
Inv001 It Will Be Only 001


Thanks

 

[Ranman256]

Did you use:
"Inv" & txtNumber

 

[arnelgp]

you keep on "Liking" this page: Custom Number Field | Page 2 | Access World Forums (access-programmers.co.uk)
what sequence do you have?

 

[Minty]

Your display format is probably adding the Inv to the displayed value, but your data is still a number.
Store it as number then you won't be trying to tie up two different data types further down the line.

Adding "Inv" to the front of it isn't telling you anything you didn't already know.