Concatenating data in a single field

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];
 
F

fredg

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.
 
P

Pharoh

hehe..I know I did. ONe reason is I didn't see a way to edit the
original so I made a new one.
 
Top