Search results

That's a huge help, thanks again Bob, obvious really if you know these things but I've been thrown in at the deep end and trying to get my head around Access so apologies for the lack of basic understanding. thanks again. Jon.

Hi Bob, thanks for the really quick response, much appreciated. This is probably where I've made the schoolboy error, the DATEDIF is sitting in a Form not a query and being dim I can't see how to do that. BUT your second solution is genius, lateral thinking at it's best! :) Thanks again Bob.

Morning All, I have a problem which i'm sure is easy to overcome but can't think how to do it for the life of me. I have split from with a field using: =DateDiff("d",[File Sent Date],Date()) which works perfectly in so far as telling me how many days have elapsed since the "File Sent...

Evening All, Many, many thanks for all your quick and detail replies, I've a lot go through and play with now which is a great help. Thanks again for helping this newcomer! Regards, Jon.

Thanks for the quick reply Steve. That's kind of what I was thinking. I'll have a look at your example when I get in this evening as 1/ I can't get it to work if I use a button to call the code or place it in an event 2/ secondly I get my head around how it will then store the updated note if...

Afternoon All, Please forgive me if this is blindingly obvious but wondered if anyone could point a newcomer me in the right direction. I have a basic database where one of the fields is for job update notes (long text). Currently I allow that to be opened and edited by users. I'm now...