Generate NUmber

D

derrick

hi
Have a customer table with these fields: LastName;FirstName; Time(24 hour
clock)
want to generate an automatic number use the 1 letters of last name and
first name and the clock time.
for example bush, george, 18:00hr. then number should be BG1800
THANKS
 
J

John Spencer

You can get that by using a formula.

Left([LastName],1) & Left([Firstname],1) & Format([Time],"hhnn")

That will not work as a field, but can be calculated whenever you need it.
If you have to store the redundant data in the table, you will have to use a
query or vba code in a form to store the value into the field.
 
Top