Recent content by ZoomerZ

You people getting further and further from "Friendly" aspect of killing...

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]

[wink]

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?

The only friendly fire is a Fireworks!

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

...if commom sense is turned off, right?

So being killed by spouse is Lovely death then? I insist that Friendly Fire was misused and overlooked and should be terminated.

We talking Access right?

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?

FRIENDLY FIRE"? Is this the same with "Amish drive-by shooting"?

I knew that:-D

Purple?

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.