Date Issue

[millertimecu32]

I am trying to add three different fileds to create a unique ID. Two of them are formated as text and the third is date. The issue that i am dealing with is that the date is formated as ex. 8/12/2008. What i would like is 8122008 so i want to remove the "/s". Does anyone know how to do this?

 

[MSAccessRookie]

I am trying to add three different fileds to create a unique ID. Two of them are formated as text and the third is date. The issue that i am dealing with is that the date is formated as ex. 8/12/2008. What i would like is 8122008 so i want to remove the "/s". Does anyone know how to do this?

Becasse the type of your field is date, the following query should work

SELECT Format([COLOR=red][B]YourDateField[/B][/COLOR],"mmddyyyy") from [COLOR=red][B]YourTable[/B][/COLOR];

Note that the Text in red needs to be replaced with the proper values for your application.

 

[millertimecu32]

Thanks....... it was right in front of me..... its been a long week.