Auto sum number?

[CAM]

Hi,

I want to have the ability to automatically assign a number (date) and put a
two letter character when the user adds a record. For example.

When a user adds a record I would like the field to automatically puts
today's data as: 04212006 then the user can input a surfix. something like
this 04212006-SP. Is this possible or does the user have to input the date
manually and then add the surfix. Any tips will be appreciated. Thank you
in advance.

 

[tina]

i'd probably use two fields: an actual Date/Time field to store "today's"
date for each record (using a date-stamp field is very common in data
tables), and a separate field for the suffix. when you *display* the data in
a query, form, or report, you can format the date value any way you want,
and you can concatenate it with the suffix field. for example:

Format([DateFieldName], "mmddyyyy") & "-" & [SuffixFieldName]

hth

 

[CAM]

Thanks Tina,
For your help on this and a previous questions.
Regards

i'd probably use two fields: an actual Date/Time field to store "today's"
date for each record (using a date-stamp field is very common in data
tables), and a separate field for the suffix. when you *display* the data
in
a query, form, or report, you can format the date value any way you want,
and you can concatenate it with the suffix field. for example:

Format([DateFieldName], "mmddyyyy") & "-" & [SuffixFieldName]

hth

Hi,

I want to have the ability to automatically assign a number (date) and
put a
two letter character when the user adds a record. For example.

When a user adds a record I would like the field to automatically puts
today's data as: 04212006 then the user can input a surfix. something like
this 04212006-SP. Is this possible or does the user have to input the date
manually and then add the surfix. Any tips will be appreciated. Thank you
in advance.

 

[tina]

you're welcome

Thanks Tina,
For your help on this and a previous questions.
Regards

i'd probably use two fields: an actual Date/Time field to store "today's"
date for each record (using a date-stamp field is very common in data
tables), and a separate field for the suffix. when you *display* the data
in
a query, form, or report, you can format the date value any way you want,
and you can concatenate it with the suffix field. for example:

Format([DateFieldName], "mmddyyyy") & "-" & [SuffixFieldName]

hth

Hi,

I want to have the ability to automatically assign a number (date) and
put a
two letter character when the user adds a record. For example.

When a user adds a record I would like the field to automatically puts
today's data as: 04212006 then the user can input a surfix. something like
this 04212006-SP. Is this possible or does the user have to input the date
manually and then add the surfix. Any tips will be appreciated. Thank you
in advance.