Search results

On second thoughts just try Int(your field) as dates are a stored as a Double with before the decimal point being the year and after the time. Brian

The use of NOW() will include a Time , you should have used Date() lookup Datevalue function Brian

This really did make me laugh out loud , not just a LOL Brian

Libre I recall that incident and what offended me was a direct personal insult, further more on a person that could not defend theirselves. Col's rantings are usually general and aimed at nobody in particular, but if somebody decides to take them personally then I suppose they will offend. Yes...

Exercise in itself will not cause you to lose weight , its calories in < calories out that does it, beer is very high in calories. Brian

You are not sensitive as Americans , tho not sure what that actually means, but you are sensitive. Not all Americans are so sensitive, when my my wife and I spent a good evening with Shaneman in Dallas, he used to be a poster on here, Access was off the agenda, but when our wives started talking...

Actually frothy he used to contribute to the technical area quite a bit in the old days, all lost now because of the hack and time although I think some can be dragged out of the archives, not sure about that. Like me he is no longer working and is out of touch so leaves it to the more upto date...

I'd just ignore ignorance, I learnt to do that as a kid when I first started wearing specs, the four eyes jibes soon ceased. Brian

Thinking about it I didn't actually support Col so much as criticise those that over reacted to him, Anthony did likewise later. Brian

Did you are not going to use a database then maybe you could just use a Word document. Brian

I'm sorry Libre but that is a load of rubbish, which is quite astonishing coming from somebody whose posts are usually intelligent. BTW did you notice that I am the only person who bothered to enter the original discussion, the rest of you were to busy crying, and no you don't have to be super...

I agree, I always used Case Else as an error message case, not to mop up those I could not be bothered coding directly. Brian

When searching for something on here I realised that I had not commented on the above, yes one or other of the two ladies got quite upset as we "discussed" the lack of indoor plumbing up North so that in the end I had to post a picture of my bathroom to prove that we did indeed have it. Brian

LOL, you realise that you will now be in trouble with our American cousins, the problem was that there was no canned laughter to indicate that it was a joke. I would point out that Col does poke fun at other people not just the yanks, but we don't get all uptight about it, and yes he does go...

Does it have to be 16/8? I seem to have followed a 14/10 regime for most of my life, just thought that was normal, or is the real issue skipping a meal? I know a chap who had great success following the 5/2 day system. Brian

Why do Americans overreact to Col, either just ignore him or join in the banter. Way back when I was working on a trip to America an American said to me during a social discussion, "we seem to either live in the gym of Macdonald's" , why can't the Americans on here be a bit more laid back. Libre...

:confused: Surely I am not the only one who thinks that there are considerable inconsistencies here , heck the man must definitely be religious. Brian

And BTW 75 is far too young, many very active members of our U3A are well over 80 and I certainly feel that I've got more than one year left. Brian

Col you have to be carefull not to react too quickly as the medical profession can't always be accurate, what we really need is assisted dying when the time is right. My wife was given 3 to 10 with a probable 5 years when her first cancer was diagnosed, she knew that the end could be drawn out...

I have never had any problems with Dateserial. Are your parameters defined as dates? Have you tried Between.... and .... Brian