You wrote: In an empty column to the right of the other data, type.
We agreed that it was Access.
I want to use query as
Select [Pay Date].[Master_Table]
From [Master_Table]
Sometimes I just don't get it...sorry, you lost me.
Let say I will use
Select [Pay Date].[Master_Table]
From [Master_Table]
So where that formula would go?
It is giving me blank value
I've tried to use it as a parameter so it asks me for date and I copy/pasting it fron table - blank....
And what is ConvertedDate? I couldn't find this function. Do I need to add references?
thanks
Beard fleas is exceptable guess I guess...
As soon as I read "Friendly Fire" it popped up in my head but where did I hear that? Comedy channel about mutualy exclusive terms or something?
I have this data in Access pasted from PeopleSoft where Date field is Text but contains mix of "mm/dd/yyyy" and "mmddyyy" dates for whatever reason beyond my control.
How do I convert all into "mm/dd/yyyy" if simple Format function wouldn't do?
EVERYBODY,
HAPPY NEW YEAR!!!
Whatever you wished for may come true in 2005.
Thanks for wonderful times and hope there are more to come.
You make great impression.
See you next year...
Yours truly ZZ.
MakeItSo,
reminds me of a joke when reader asked horrible untalented writer after reading his discuisting book...
-Sir, have you EVER read your book?
-No! answered writer
I am not A READER, I am A WRITER...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.