Search results

I'm glad that you are happily satisfied Doc Brian

Why the Array? Why not two simple Print commands? Brian

Why are people surprised that there are patches? Windows is a huge piece of software interfacing with many variations of hardware and apps. We used to say back in the 1960s when I first started that we could test for months only for the young girls in the office to break the program in minutes...

This thread is nearly a year old, I think Bob is long gone. Brian

Sum(IIf(checkboxname=FALSE,[cost],0)) Brian

Actually Col my remarks were aimed at the first post, think about it, but I can see how you could think that it might include you. I apologise to the forum members for my language in the failed attempt at humour. Brian

Col, I would point out that this is the Watercooler not the Debates forum, therefore one can post the sort of throw away comment people make at Watercoolers, however at the Watercooler in the office I worked, coffee machine actually, a shitty comment could expect a shitty reply and you lived...

Yes Vass is of course correct he did suffer a second ban. My bad Brian

He, and a guy called Rich, were not banned but deleted from the forum by a mod they were having an argument with, again it was a mountain made out of a molehill. They were reinstated but lost thousands of posts, many , maybe most, from the technical threads. The guy apologised and resigned his...

Typical Col, but then he goes to Starbucks,'nuff said. :eek: brian

I don't follow multi-day cricket, a stupid game usually decided by who wins the toss, but the last match scores would suggest that we sent the blind school. Brian PS perhaps we should send out our ladies , they apparently won.

Then could you please explain Pbaldy's post. I know Col can be a pain and likes to wind people up but it appears to me that it is Burrina who was rude in the highlighted thread , and Col was not the only one who found the first post puzzling. Brian

A simple mistake and they can be the hardest to spot, happy to have helped. Brian

Datedif is an old Lotus function Microsoft provided for compatibility ages ago but stopped showing it in help after Excel 97 but still permit it to work. It is superior to Datediff. I was saying that other functions also are different, therefore the actual formula code will differ, so why not...

You were getting the number of days not years. It pays to do a test with a short date span , say 1 year, 2 months 3 days as things can be easily calculated manually and errors spotted. Brian

Going by some of his recent posts burrina seems to have moaning pedantic bee in his bonnet Brian

So a new born is a sinner, just by being born, an event it had no control over, what a ridiculous religion you follow. Brian

If you mean Liberalism, well it means anything Blade wants it to, a Liberal is somebody that Blade disagrees with. Brian

=DATEDIF(A4,TODAY(),"Y") &" Years, "&DATEDIF(A4,TODAY(),"ym") &" Months, " &DATEDIF(A4,TODAY(),"md") &" Days" Produces the same results as Bob's code. Don't see how you can use the identical formula in both Excel and a DB , definitely in Access the functions and addressing will be different...

It is a long time since I did this, 10 years retired, but don't you just need three Datedif using "Y" "YM" "MD" although I may need to check the codes. I will switch to my laptop from my iPad after I have finished watching the Tour De France. Brian