How to join auto number and letters

G

Guest

Hi,
I have a form for issuing a letter number for our letter book. In this form
, I have a text box with auto number . what I need is to issue auto number
start with letters. For example: APP&P1, which 1 is the auto number and it is
start with “APP&Pâ€. once the user complete the letter subject, letter receive
and the sender , will receive a control number or letter number.
 
D

David Portwood

What about having two fields, where the first field contains the letter
prefix and the second field contains the number? You could display the two
fields in a calculated control combining the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique number 2
Unique number 8
Unique identification number 3
Update unique number 8
Searching query in form 4
MS Access problem 0
Letters to cut 3
Does Winword have a function to automatically add days to date? 1

Top