Concatenating data in a single field

  • Thread starter Thread starter Pharoh
  • Start date Start date
P

Pharoh

I have a field with data that's formatted like so 24:12.12

what I would like to do is Concatenate the data so that it shows up
like this 2412

So basically, I wanna drop the : . and 12. Is there a way to do this in
my original query or do I have to do it afterwards?

SELECT [Extract_Current].[BCI DIN], [Extract_Current].[BCI SUBCLASS]
FROM Extract_Current LEFT JOIN CRS_EHB_DIN ON [Extract_Current].[BCI
DIN]=[CRS_EHB_DIN].[DIN]
WHERE ((([CRS_EHB_DIN].[DIN]) Is Null))
ORDER BY [Extract_Current].[BCI DIN];
 
I have a field with data that's formatted like so 24:12.12

what I would like to do is Concatenate the data so that it shows up
like this 2412

So basically, I wanna drop the : . and 12. Is there a way to do this in
my original query or do I have to do it afterwards?

SELECT [Extract_Current].[BCI DIN], [Extract_Current].[BCI SUBCLASS]
FROM Extract_Current LEFT JOIN CRS_EHB_DIN ON [Extract_Current].[BCI
DIN]=[CRS_EHB_DIN].[DIN]
WHERE ((([CRS_EHB_DIN].[DIN]) Is Null))
ORDER BY [Extract_Current].[BCI DIN];
Click to expand...

Already answered.
A little patience helps. You posted a similar message just 40 minutes
ago.
 
hehe..I know I did. ONe reason is I didn't see a way to edit the
original so I made a new one.
 
Back
Top