Search results

:banghead::banghead::banghead::banghead::banghead::banghead::banghead: I have a report with 7 calculated fields. Conditional formatting through the Conditional Formatting Rules Manager work wonderfully on 5 of them. The last 2 are formatted on an expression based on an OnLoad calculation based...

Thanks both. I've just come back from a long and much needed holiday in the sun. Your help has both been invaluable and appreciated. From reading through, I feel I've been doing my usual trick of over-complicating things. I've managed to fix the problem I was having by using the same simple...

Thanks all for your replies. Sneuberg, I have read the article you have suggested and it all makes sense now. It's all knowledge that goes into the Bank. Thank you! The updated SQL string you posted however brings me back to the 3075 error. In saying that, having some time over the weekend to...

Thanks for getting back to me so quickly! I've tried your amendment to the SQL. I'm not getting the error anymore (WIN!) but I'm still not getting the records I'm after i.e. Date set on the form is 1st June, but it's pulling records from before that. I wonder if this is the problem... I...

Hi all, There is a very long story behind this but I'll just post my current problem for now... Essentially, I'm trying to create an active employee list from a central 'employees table' table in order to run a variety of queries from it which will be date sensitive I'm kinda new to the idea of...

Hi all, I'm based in South Wales, UK. Lovely part of the world (if you know where to look!) I work primarily as a Team Leader in a contact centre but I was given an opportunity in Feb 2016 to work on some analysis projects. My experience in Excel was fairly extensive but it became quite clear...