Order Numbers

[Simon]

I currently have order Numbers going 1, 2, 3 ect

Ther order Numbers are calculated using
CLng(Nz(DMax("OrderNumber","tblOrder"),0))+1 as the default value on
the form

I would like to set it up to have order number like

HT1, HT2, HT3 ect

how do i get it to put HT infront of all the numbers


Tahnsk


Simon

 

[Al Campagna]

Simon,
If it's ALWAYS "HT"... make the field text in your table.
Default = "HT" & CLng(Nz(DMax("OrderNumber","tblOrder"),0)) + 1
or...
A better solution is to just leave the OrdNo fieldas it is, (hide it though) and
create an unbound calculated field with
= "HT & OrdNo
and display that on your form.
The HT can also be concatenated "on the fly" in any subsequent query or report.