format OXXXXXO

I have a field in a query called DELDAYS in the field the date reads 0XXXXX0
how can I for matt this so it will show as SMTWTHFS? This date represent the
day of the week in some case it will be different combo’s I am new to VB can
anyone help with this? thanks octet

Hi -

I'm a little confused.

1) Is the field an actual date/time field?

2) Given that today is Wed 30 Dec 2009, what is it that you would want to see?


Bob

Octet32 wrote:
I have a field in a query called DELDAYS in the field the date reads 0XXXXX0
how can I for matt this so it will show as SMTWTHFS? This date represent the
day of the week in some case it will be different combo’s I am new to VB can
anyone help with this? thanks octet

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200912/1

the field shows custmer del days as 0XXXXXO this mean monday thu friday i
would like it to show NYYYYYN or SMTWTHFS so i can match it to anther table

"raskew via AccessMonster.com" wrote:

Hi -

I'm a little confused.

1) Is the field an actual date/time field?

2) Given that today is Wed 30 Dec 2009, what is it that you would want to see?


Bob

Octet32 wrote:
I have a field in a query called DELDAYS in the field the date reads 0XXXXX0
how can I for matt this so it will show as SMTWTHFS? This date represent the
day of the week in some case it will be different combo’s I am new to VB can
anyone help with this? thanks octet

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200912/1

.

In A2000 and later you can use the Replace() function to convert your OXXXXXO
to NYYYYYN.
Before trying this BACKUP your DB.
Create an update query showing just the DelDays field. In the UpdateTo cell
place
Replace([DelDays], "X", "Y"). Run the query then do it a second time using
Replace([DelDays], "O", "N").

HTH - Bob


Octet32 wrote:
the field shows custmer del days as 0XXXXXO this mean monday thu friday i
would like it to show NYYYYYN or SMTWTHFS so i can match it to anther table

Hi -

[quoted text clipped - 10 lines]
day of the week in some case it will be different combo’s I am new to VB can
anyone help with this? thanks octet

--
Message posted via http://www.accessmonster.com

Thanks but i only need to convert to this format to querry.
i am conecting to the DB with ODBC I dont want to update the field just
chang it in the querry

"raskew via AccessMonster.com" wrote:

In A2000 and later you can use the Replace() function to convert your OXXXXXO
to NYYYYYN.
Before trying this BACKUP your DB.
Create an update query showing just the DelDays field. In the UpdateTo cell
place
Replace([DelDays], "X", "Y"). Run the query then do it a second time using
Replace([DelDays], "O", "N").

HTH - Bob


Octet32 wrote:
the field shows custmer del days as 0XXXXXO this mean monday thu friday i
would like it to show NYYYYYN or SMTWTHFS so i can match it to anther table

Hi -

[quoted text clipped - 10 lines]
day of the week in some case it will be different combo’s I am new to VB can
anyone help with this? thanks octet

--
Message posted via http://www.accessmonster.com

.

On Wed, 30 Dec 2009 07:54:01 -0800, Octet32
wrote:

Thanks but i only need to convert to this format to querry.
i am conecting to the DB with ODBC I dont want to update the field just
chang it in the querry

You can do this in a select query as well as in an update query. Try:

NewDelDays: Replace(Replace([DelDays], "X", "Y"), "O", "N")

You should then be able to use NewDelDays to link to your external table.
--

John W. Vinson [MVP]

Thanks for that John -

I envisioned a similar solution but didn't even try it, thinking it wouldn't
work.

Best wishes - Bob
John W. Vinson wrote:
Thanks but i only need to convert to this format to querry.
i am conecting to the DB with ODBC I dont want to update the field just
chang it in the querry

You can do this in a select query as well as in an update query. Try:

NewDelDays: Replace(Replace([DelDays], "X", "Y"), "O", "N")

You should then be able to use NewDelDays to link to your external table.

--
Message posted via http://www.accessmonster.com