Recent content by thefiddler

Many thanks PBaldy and I understand your reply, however there is another scenario that I need answering and your the possible man to do it. I have an Access 2007 database of 12,000 records with various numbers of records per day. I have fields of Date, Time, Cost. What I am trying retrieve is...

Can anyone help with building a Query/Syntax in Access 2007, for extracting records from a time and date range of lets say today 0300hrs until Tomorrow 0300hrs. It's driving me nuts !!! :mad: Thanks in advance :rolleyes:

Office Version:Office 2007 Operating System:Windows Vista I have Microsoft Access 2007 and a database of 12,000 records (inputed over 2 years) with fields named: Date, Time & Daily Cost. My question is how do I create a specific query so that I can retrieve the total "Daily Costs" over each...