|
|
merge multiples fields into one
Hello. I triyng to merge multiples fields into one but I'm not being very
sucessful.
I have in my form field A and field B and C
I want to save right into field C the concanetanet or merger of fields A and B
A=gh
B=yh
C=ghyh
I tried into the code to do this C=A&B
Regards,
Marco
|
|
0
|
|
|
|
Reply
|
 Utf
|
12/20/2007 1:12:02 AM |
|
See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
The article explains how to get Access to give you C *without* storing it in
a table.
If you really want to do it anyway, the acticle explains how to put your
line of code into the AfterUpdate event procedure of both text boxes (A and
B.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Marco" <Marco@discussions.microsoft.com> wrote in message
news:871DAC9F-CB0D-4A53-BDD1-7076801BCEF2@microsoft.com...
> Hello. I triyng to merge multiples fields into one but I'm not being very
> sucessful.
>
> I have in my form field A and field B and C
>
> I want to save right into field C the concanetanet or merger of fields A
> and B
>
> A=gh
> B=yh
> C=ghyh
>
>
> I tried into the code to do this C=A&B
>
> Regards,
> Marco
|
|
|
0
|
|
|
|
Reply
|
Allen
|
12/20/2007 1:58:10 AM
|
|
|
1 Replies
435 Views
(page loaded in 0.032 seconds)
Similiar Articles: merge multiples fields into one - microsoft.public.access.forms ...Hello. I triyng to merge multiples fields into one but I'm not being very sucessful. I have in my form field A and field B and C I want to save rig... Combine multiple rows into one row with multiple columns ...Hi, I have a table set up so that there are three columns: StudyID, DrawDate, and Value. StudyID and DrawDate are the primary key. I want to cr... Export to Excel - combine multiple fields in one cell - microsoft ...Export to Excel - combine multiple fields in one cell - microsoft ... Match and combine multiple rows into one - microsoft.public.excel ... Export to Excel - combine ... Combining multiple records into one memo field - microsoft.public ...Combining multiple columns into single column based one another ... merge multiples fields into one - microsoft.public.access.forms ... Combining multiple records into one ... Merging two fields into one? - microsoft.public.access.forms ...Merging multiple spreadsheets by matching columns - microsoft ... They had an excel spreadsheet with two columns. Column A was ... How to Merge Multiple Columns Into One ... Merge multiple records in a field, based on criteria? - microsoft ...merge multiples fields into one - microsoft.public.access.forms ... Merge multiple records in a field, based on criteria? - microsoft ... Multiple Worksheets Into 1 Based ... Combining multiple columns into single column based one another ...Combining multiple records into one memo field - microsoft.public ... Combine ... Combining multiple columns into single column based one another ... Combine multiple ... Combine multiple tables into one - microsoft.public.access ...Combine multiple rows into one row with multiple columns ... Hi, I have a table set up so that there are three columns: StudyID, DrawDate, and Value. Match and combine multiple rows into one - microsoft.public.excel ...Hi all, I have the data set below in three separate columns in one worksheet A3 B3 C3 10 71 120171 10 71 43311 10 71 43312 10 72 10132... Merge a field data for all records in a table into one output ...merge multiples fields into one - microsoft.public.access.forms ... Merge a field data for all records in a table into one output ... merge multiples fields into one ... How to Merge Multiple Columns Into One Column | eHow.comMicrosoft Excel and Google Spreadsheets are two programs that allow you to sort information into blocks of data called columns. Columns allow you to break data down ... Excel Join Combine Multiple Rows or Columns Into One - CNET ...Easily join multiple rows or combine multiple columns into one big long column or one entire row. Using this software, you can: easily select a group of rows or a ... Excel: merge cells, combine columns and rows in Excel 2010, 2007Merge multiple Excel cells into one and keep all data. Combine information by columns or rows in Excel 2010, 2007 and 2003 and never see 'the selection contains ... Join multiple Excel cells into one - Combine multiple text cells ...Join multiple Excel cells into one Combine Excel cells, columns and rows keeping all values How do i combine multiple columns into one column in excel 2007 ...Best Answer: To stack data in columns A through M into Column N use the following subroutine. Sub Stack() Dim iRow, iCol, iTargetRow, iMaxRow As Long ... 7/30/2012 9:14:58 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 