Auto sum number?

  • Thread starter Thread starter CAM
  • Start date Start date
C

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.
 
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
 
Thanks Tina,
For your help on this and a previous questions.
Regards

tina said:
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 said:
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.
Click to expand...
Click to expand...
 
you're welcome :)


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

tina said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top