Concatenate

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I am trying to create the "ComboField". The field is composed of Date, Left 4
Characters of DealID, and PhaseID. Can someone show me the sql for doing
something like this ?

Date DealID PhaseID ComboField
20090928 0549SA1 1 2009092805491
20090928 0549SA1 2 2009092805492
20090928 0549SA1 1 2009092805491
20090928 0642SA1 1 2009092806421

Thank you in advance.
 
If your 'Date' field is a Text field then use this --
ComboField: [Date] & Left([DealID], 4) & [PhaseID]

If your 'Date' field is a DateTime field then use this --
ComboField: Format([Date], "yyyymmdd") & Left([DealID], 4) & [PhaseID]

If any field is null then nothing will display or you could use this --
ComboField: IID([Date] Is Null OR [DealID] Is Null OR [PhaseID] Is Null,
"Error", [Date] & Left([DealID], 4) & [PhaseID])
Or --
ComboField: IID([Date] Is Null OR [DealID] Is Null OR [PhaseID] Is Null,
"Error", Format([Date], "yyyymmdd") & Left([DealID], 4) & [PhaseID])
 
carl said:
I am trying to create the "ComboField". The field is composed of Date, Left 4
Characters of DealID, and PhaseID. Can someone show me the sql for doing
something like this ?

Date DealID PhaseID ComboField
20090928 0549SA1 1 2009092805491
20090928 0549SA1 2 2009092805492
20090928 0549SA1 1 2009092805491
20090928 0642SA1 1 2009092806421
Click to expand...


The calculated field could use an expression like:

ComboField: Format(datefield, "yyyymmdd") & Left(DealID,4) &
PhaseID
 
Back
Top