Hi, I need help with Microsoft Access 2003.
In one of the fields of a table I need to auto generate a unique reference ID using a combination of letters, numbers and information from another field. For example: ABC-DE000-FG-00/00/00 (auto number) (information from other field (Date)).
I can do...