Concatenate

[ram]

I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from a date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however it won’t
concatenate with the employee number


Thanks in advance for any help

 

[Douglas J. Steele]

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

 

[ram]

HI Douglas,

I was not able to get your code to run in my update query. I was looking for
the result shown in the concatenated field below. When i split your code the
process date shows as 20081101 but I was hoping for 39753.

I still was not able to get the concatenation to work.

Thanks for any additional help

Process_Date Field Employee_Num Field Concatenated Field
11/1/2008 123456 39753123456

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from a date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however it won't
concatenate with the employee number


Thanks in advance for any help

 

[Douglas J. Steele]

Sorry, I thought seeing the date as a date would be more meaningful.

To get 39753 instead, use

Format([Process_Date], "#") & CStr([Employee_Num])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

HI Douglas,

I was not able to get your code to run in my update query. I was looking
for
the result shown in the concatenated field below. When i split your code
the
process date shows as 20081101 but I was hoping for 39753.

I still was not able to get the concatenation to work.

Thanks for any additional help

Process_Date Field Employee_Num Field Concatenated Field
11/1/2008 123456
39753123456

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from a
date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however it
won't
concatenate with the employee number


Thanks in advance for any help

 

[ram]

HI Douglas,


Thank you for your reply, I have the date serial number working however i
still can't get the concatenate to work after i update the process_date field.

Thanks for any additional help

Ramone

Sorry, I thought seeing the date as a date would be more meaningful.

To get 39753 instead, use

Format([Process_Date], "#") & CStr([Employee_Num])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

HI Douglas,

I was not able to get your code to run in my update query. I was looking
for
the result shown in the concatenated field below. When i split your code
the
process date shows as 20081101 but I was hoping for 39753.

I still was not able to get the concatenation to work.

Thanks for any additional help

Process_Date Field Employee_Num Field Concatenated Field
11/1/2008 123456
39753123456

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from a
date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however it
won't
concatenate with the employee number


Thanks in advance for any help

 

[Douglas J. Steele]

In what event are you putting your code?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

HI Douglas,


Thank you for your reply, I have the date serial number working however i
still can't get the concatenate to work after i update the process_date
field.

Thanks for any additional help

Ramone

Sorry, I thought seeing the date as a date would be more meaningful.

To get 39753 instead, use

Format([Process_Date], "#") & CStr([Employee_Num])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

HI Douglas,

I was not able to get your code to run in my update query. I was
looking
for
the result shown in the concatenated field below. When i split your
code
the
process date shows as 20081101 but I was hoping for 39753.

I still was not able to get the concatenation to work.

Thanks for any additional help

Process_Date Field Employee_Num Field Concatenated
Field
11/1/2008 123456
39753123456




:

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from
a
date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however
it
won't
concatenate with the employee number


Thanks in advance for any help

 

[ram]

an update query

In what event are you putting your code?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

HI Douglas,


Thank you for your reply, I have the date serial number working however i
still can't get the concatenate to work after i update the process_date
field.

Thanks for any additional help

Ramone

Sorry, I thought seeing the date as a date would be more meaningful.

To get 39753 instead, use

Format([Process_Date], "#") & CStr([Employee_Num])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


HI Douglas,

I was not able to get your code to run in my update query. I was
looking
for
the result shown in the concatenated field below. When i split your
code
the
process date shows as 20081101 but I was hoping for 39753.

I still was not able to get the concatenation to work.

Thanks for any additional help

Process_Date Field Employee_Num Field Concatenated
Field
11/1/2008 123456
39753123456




:

You mean Employee_Num is a numeric field?

Try:

Format([Process_Date], "yyyymmdd") & CStr([Employee_Num])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I would like to ask for help with the following question:

I would like to know how to concatenate the date serial number from
a
date
field with a general number field

DateValue([Process_Date]) & [Employee_Num]

The datevalue function changes the date to a serial number however
it
won't
concatenate with the employee number


Thanks in advance for any help