Access 2007 Query Dilemma ?????

[thefiddler]

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 day of the week but between the hours of: Monday 0300hrs & Tuesday 0259hrs (example). Thanks in advance

 

[RuralGuy]

I would start by renaming the Date and Time fields to something that was not a Reserved word. http://www.allenbrowne.com/AppIssueBadWord.html

 

[pbaldy]

Note this question was also asked here:

http://www.access-programmers.co.uk/forums/showthread.php?t=199488