Concatenate

[ram]

Because of the problems with this site, I'm reposting a follow-up question.
Sorry for any confusion

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.

I' am hoping the output looks like the concatenated field shown below

Thanks for any additional help

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

 

[KARL DEWEY]

Try this --
Val([Process_Date]) & [Employee_Num]

 

[Maarkr]

clng(#1/1/09#) = 39814
clng([datefield])

 

[ram]

HI Karl,

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

Try this --
Val([Process_Date]) & [Employee_Num]
--
KARL DEWEY
Build a little - Test a little

Because of the problems with this site, I'm reposting a follow-up question.
Sorry for any confusion

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.

I' am hoping the output looks like the concatenated field shown below

Thanks for any additional help

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

 

[ram]

HI Maarkr

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

clng(#1/1/09#) = 39814
clng([datefield])

Because of the problems with this site, I'm reposting a follow-up question.
Sorry for any confusion

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.

I' am hoping the output looks like the concatenated field shown below

Thanks for any additional help

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

 

[KARL DEWEY]

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[ram]

Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[KARL DEWEY]

after i update the process_date field
How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little

Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

can't get the concatenate to work after i update the process_date field.

What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[ram]

The concatenation never worked

How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little

Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[KARL DEWEY]

Post your complete query SQL.
--
KARL DEWEY
Build a little - Test a little

The concatenation never worked

after i update the process_date field

How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little

Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

:

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[ram]

UPDATE qryAllowanceDetailReimb SET qryAllowanceDetailReimb.TEST3 =
Val([qryAllowanceDetailReimb]![Process_Date]) &
[qryAllowanceDetailReimb]![Employee_Number]

Thanks,

Post your complete query SQL.
--
KARL DEWEY
Build a little - Test a little

The concatenation never worked

after i update the process_date field
How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little


:


Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

:

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[KARL DEWEY]

Is qryAllowanceDetailReimb a table or query?
You can not update a query.
--
KARL DEWEY
Build a little - Test a little

UPDATE qryAllowanceDetailReimb SET qryAllowanceDetailReimb.TEST3 =
Val([qryAllowanceDetailReimb]![Process_Date]) &
[qryAllowanceDetailReimb]![Employee_Number]

Thanks,

Post your complete query SQL.
--
KARL DEWEY
Build a little - Test a little

The concatenation never worked


:

after i update the process_date field
How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little


:


Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

:

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[ram]

It was a query that I made a table to test with

Is qryAllowanceDetailReimb a table or query?
You can not update a query.
--
KARL DEWEY
Build a little - Test a little

UPDATE qryAllowanceDetailReimb SET qryAllowanceDetailReimb.TEST3 =
Val([qryAllowanceDetailReimb]![Process_Date]) &
[qryAllowanceDetailReimb]![Employee_Number]

Thanks,

Post your complete query SQL.
--
KARL DEWEY
Build a little - Test a little


:

The concatenation never worked


:

after i update the process_date field
How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little


:


Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

:

can't get the concatenate to work after i update the process_date field.
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?

 

[Dirk Goldgar]

Is qryAllowanceDetailReimb a table or query?
You can not update a query.

Yes you can, so long as it's an updatable query.