Search results

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...

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...