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.
I am not sure if it belongs here but seems like it...
I just read it (and keep laughing) when lady complained about her friend acting stupid. Another lady suggesting that "she is one sandwich short from a picnic"
I love these phrases so much and wondering is this amuses me so much because I am...
OK, ESL people like me often confuse by necessary and necesserily words.
I feel that it should be use like this: "It is not necesary to curse while driving. But if person does curse it is not necessarily because he has other issues."
I think I've used it correctly but I can not explain why...
Hi!
I have 2 spreadsheets.
I need to enter LOOKUP formula on Spreadsheet1 to get value from Spreadsheet2
So far it is VLOOKUP(B2,emp2,False)
emp2 is the name of the Spreadsheet2
Is there error in formula?
It stays as formula - no result
Thanks
Guys,
I am figuring this out but I have to present it by 11am and I doi not work good under time pressure,
so here I go:
Acess Report that have to be sorted desc by field that is formula :
=IIf(IsNull(Sum([Employee Name])),"",("$" & "" & Sum([Employee Name])*250))
How do I do that?
Thanks so much
I am glad I found this forum as search on Peoplesoft didn't bring anything...
OK, here is the story. I am creating a Reporting System and client using PeopleSoft. No one so far could tell me which Reporting tool they want to use, so I need to suggest.
Please, help me to understand: if you were...
Hi again!
I have this Access Report I was suppose to add 5 Sorting Headers/Footers so now it looks like
Executive
Unit
CostCenter
Location
Manager
Is there way to get it all to the same level. It take...
I ran into some problem I don't know what to make of it...
I am writing a Macro in Access:
___________________________________________________________
Action Comment
---------------------------------
OpenQuery 01 - Delete Some Table
---------------------------------
QueryName 01 - Delete...
gbaughma wrote
...Getting into management has always been a good option, because *good* managers are hard to find, and good managers that understand IT are almost non-existant.
and inspired my question: Is there IT Management school or course or something?
I hope I am in a right place.
My PC use to work fine with chats and games when all of a sudden I can't get that applet to load.
I have my Java enabled in Internet Options.
Please, advise.
Thanks
Have anyone ever used http://www.geowebservices.com for a job search?
It says it is paid but there is an option for free trial I can't find. Any feedback would be appreciated
Thanks
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.