format OXXXXXO

  • Thread starter Thread starter Octet32
  • Start date Start date
O

Octet32

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
 
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
 
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 said:
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

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 -
Click to expand...
[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
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...

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.
 
Back
Top