If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine field entries in new field
Is there a way in design view to run a query that will combine the entires of
one field into another field? For instance, I have 1 field that is NAME and a second field which is DATA. For the same name there can be multiple DATA (A or B or C), which are alpha not numeric. I want craete a third field which either combines all the DATA entries (A, A B, A C, A B C, eetc) or can I create a third field that uses an if then statement (If DATA has only A then ___ , or If DATA has A and B then ____ , etc...). Is this possible? thanks |
#2
|
|||
|
|||
Combine field entries in new field
On Tue, 11 May 2010 06:53:01 -0700, cluckers
wrote: Check this out: http://www.mvps.org/access/modules/mdl0008.htm -Tom. Microsoft Access MVP Is there a way in design view to run a query that will combine the entires of one field into another field? For instance, I have 1 field that is NAME and a second field which is DATA. For the same name there can be multiple DATA (A or B or C), which are alpha not numeric. I want craete a third field which either combines all the DATA entries (A, A B, A C, A B C, eetc) or can I create a third field that uses an if then statement (If DATA has only A then ___ , or If DATA has A and B then ____ , etc...). Is this possible? thanks |
#3
|
|||
|
|||
Combine field entries in new field
This looks like VBA. I am familiar with VBA for excel but not so much for
Access. Where would I pu this code for Access? "Tom van Stiphout" wrote: On Tue, 11 May 2010 06:53:01 -0700, cluckers wrote: Check this out: http://www.mvps.org/access/modules/mdl0008.htm -Tom. Microsoft Access MVP Is there a way in design view to run a query that will combine the entires of one field into another field? For instance, I have 1 field that is NAME and a second field which is DATA. For the same name there can be multiple DATA (A or B or C), which are alpha not numeric. I want craete a third field which either combines all the DATA entries (A, A B, A C, A B C, eetc) or can I create a third field that uses an if then statement (If DATA has only A then ___ , or If DATA has A and B then ____ , etc...). Is this possible? thanks . |
Thread Tools | |
Display Modes | |
|
|