combining two fields in query

[Mike Hughes]

I've followed the instructions in other posts but can't get my query to work. Can someone tell me what is worng with the query? I'm trying to create a new field called "PARTYTYPE"

I'm getting error "Syntax error(missing operator)in query expression PARTYTYPE : [CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE],


SELECT
CSEME_OTHER_PARTIES.OTHER_PARTY_ID,
CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE,
PARTYTYPE : [CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE],
CSEME_OTHER_PARTIES.OTHER_PARTY_NAME,
CSEME_OTHER_PARTIES.OTHER_PARTY_AKA,
CSEME_OTHER_PARTIES.ADDRESS_LINE_1,
CSEME_OTHER_PARTIES.ADDRESS_LINE_2,
CSEME_OTHER_PARTIES.ADDRESS_LINE_3,
CSEME_OTHER_PARTIES.CITY, CSEME_OTHER_PARTIES.STATE,
CSEME_OTHER_PARTIES.ZIP, CSEME_OTHER_PARTIES.COUNTRY,
CSEME_OTHER_PARTIES.OTHER_CONTACT,
CSEME_OTHER_PARTIES.PHONE,
CSEME_OTHER_PARTIES.EMPLOYER_STATE_ID,
CSEME_OTHER_PARTIES.EMPLOYER_FEDERAL_ID INTO [CSEME 7]

FROM CSEME_OTHER_PARTIES;

 

[Trevor G]

You are showing this line:

PARTYTYPE : [CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE],

Take out the comma at the end. If you need a space between Party_ID then also use & " " & between the field names

PARTYTYPE : [CSEME_OTHER_PARTIES.OTHER_PARTY_ID]&" "&[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE]

 

[PNGBill]

Try,

[CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE] AS PARTYTYPE

 

[Mike Hughes]

I'm still getting the error

SELECT
CSEME_OTHER_PARTIES.OTHER_PARTY_ID,
CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE,
CSEME_OTHER_PARTIES.OTHER_PARTY_NAME,
CSEME_OTHER_PARTIES.OTHER_PARTY_AKA,
CSEME_OTHER_PARTIES.ADDRESS_LINE_1,
CSEME_OTHER_PARTIES.ADDRESS_LINE_2,
CSEME_OTHER_PARTIES.ADDRESS_LINE_3,
CSEME_OTHER_PARTIES.CITY, CSEME_OTHER_PARTIES.STATE,
CSEME_OTHER_PARTIES.ZIP, CSEME_OTHER_PARTIES.COUNTRY,
CSEME_OTHER_PARTIES.OTHER_CONTACT,
CSEME_OTHER_PARTIES.PHONE,
CSEME_OTHER_PARTIES.EMPLOYER_STATE_ID,
CSEME_OTHER_PARTIES.EMPLOYER_FEDERAL_ID,
PARTYTYPE : [CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE] INTO [CSEME 7]

FROM CSEME_OTHER_PARTIES;

 

[Mike Hughes]

That worked!! Thanks Mike
[CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE] AS PARTYTYPE