Concatenate

  • Thread starter Thread starter ram
  • Start date Start date
R

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
 
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

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


ram said:
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
Click to expand...
Click to expand...
 
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

Maarkr said:
clng(#1/1/09#) = 39814
clng([datefield])
ram said:
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
Click to expand...
Click to expand...
 
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?
 
Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

KARL DEWEY said:
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?
Click to expand...
 
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


ram said:
Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

KARL DEWEY said:
can't get the concatenate to work after i update the process_date field.
Click to expand...
What does the Val([Process_Date]) show?
What does Val([Process_Date]) & [Employee_Num] show?
Click to expand...
Click to expand...
 
The concatenation never worked


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


ram said:
Val([Process_Date]) shows 39753
Val([Process_Date) & [Employee_Num] shows 11123456

Thanks

KARL DEWEY said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Post your complete query SQL.
--
KARL DEWEY
Build a little - Test a little


ram said:
The concatenation never worked


KARL DEWEY said:
after i update the process_date field
Click to expand...
How are you updating the field? Did it work before update?
--
KARL DEWEY
Build a little - Test a little


ram said:
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?
Click to expand...
Click to expand...
Click to expand...
 
UPDATE qryAllowanceDetailReimb SET qryAllowanceDetailReimb.TEST3 =
Val([qryAllowanceDetailReimb]![Process_Date]) &
[qryAllowanceDetailReimb]![Employee_Number]

Thanks,



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


ram said:
The concatenation never worked


KARL DEWEY said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Is qryAllowanceDetailReimb a table or query?
You can not update a query.
--
KARL DEWEY
Build a little - Test a little


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

Thanks,



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


ram said:
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?
Click to expand...
Click to expand...
Click to expand...
 
It was a query that I made a table to test with



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


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

Thanks,



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