Creating a field entry from multiple other fields.

[Mr. Phoreal]

I am quite out of practice when it comes to coding this stuff. I have done a
little in the past, but have never been a pro.

I am creating a catalog of my photographs and want to create a self devised
ID for each image, based on entries from other fields in the same record.

Essentially I need the first 2 or three characters from the various fields
combined into a formatted code.

Example:

I am interested in three specific fields: Category, Page, and Frame Number.

I need the first two alpha characters from the Category field(the LA out of
Landscape, or EV out of Event). The three digit entry in the Page field (or
the one or two digit entry formatted into three) (4 becoming 004, 73 becoming
073, or 212 being 212). And the two or three character alpha-numeric from the
Frame field (12 being 12, or 30A being 30A).

I entend to have a unique code for each frame of film formatted as ;
AA#####(A) (the last A being optional)

I have been wrestling with the help provided to figure out the code but have
yet to get a valid string.

I appreciate the help.

 

[John Spencer]

The expression would be
Left([Category],2) & Format([Page],"000") & [Frame]


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County