Search results

Excellent, thanks for all the help guys. You've bee nfantastic. Next time you make it to Bracknell i'll buy you a beer. Time to play around with excel Macro's for a bit :) Thanks Again iPirate

Ah definetley helpful Fuga! Thanks for that. :)

Cheers for the responses Aj, right i'll have a look, but to be honest i'm a total amateur with anything VBA related so i'll be no more than a tourist prodding at commands within the code. Shrimp, it would be a case of automation as the spreadsheet needs formating by way of colours and...

Hi, wasn't sure where to post this, so general seemed the way to go. I am required to produce a weekly Excel spreadsheet containing the data held within two tables on my database, i have set up a query that collates and arranges all the neccessary data into the right format so it can be simply...

Hi, i'm currently building a whole list of queries and reports for this database of customers. I'm stuck on finding the critieria needed to pull up all records which have an insurance expiry date within the next two months. Any help would be much appreciated. Cheers iPirate

Hi there, second post still as simple as the first. i'm currently pumping out all the possible queries/reports i think this database needs and i've found myself stuck on another date related error. I'm tryng to get a query to pull out records that will expire in the next 2 months and i can't...

...Well, you were right. Knew it would be something simple. Thanks fella!

Hi all, i'm currently trying to build a simple query that shows all records that insurance has expired on. From what i can tell a simple "<=date()" criteria in the expiry date column should cover this and show all dates before and including the current date. However when i run the query i get...