I'd like to copy the date from a date field on my form, strip out the
date formatting and plant the result in another field on the form. So,
the original date field would look like this:

05/08/06

and the result would look like this:

050806

in a field I'll call: DigitalDate. I've actually gotten it to work by
setting the DigitalDate format to: mmddyy, but I believe the computer
still recognizes the "date aspects" and I get a type mismatch when I
attempt my next step - concatenating DigitalDate with a field
called:LastName. Eventually my mishmash will look like this:

SMITH050806

I am attempting to have access automatically generate an ID using my
client's last name and the date they signed-on with me. Yes, it
violates good database convention, but I have my squalid little
reasons for avoiding AutoNumber. I read a blurb on Microsoft that said
dates are stored in Access as a serial number (which to my untrained
eyes looks nothing like the date you enter). Could this make what I
seek too complex?

Thanks in advance!

The Woo <***.www.co.> wrote in news:muf062p2l7vhkebqdojef63uits0t9rhs8@
4ax.com:

I actually just did something like this in order to create a directory
for backing up files. Using the Format function should work, despite how
Access stores the date. I don't think you need two steps. Here's what
the update value would look like given your example:

mishmash = [LastName] & Format([DigitalDate],"mmyydd")

On Tue, 09 May 2006 21:31:46 -0500, Mike Easter <username (AT) domain (DOT) com>
wrote:

A simple and elegant solution which worked right out of the box! I
thank you!