Hi,
I'm trying to report on the time records are created , but not to include the date. So for a month long period, I want to know how many records have been created between 8am & 9am. I can group the records and display by hour, but as the database is a time date field, it displays for each date as well.
I think I probably need to create a formula that will strip out the date information, then I can group by hour and that will return what I need, but I have no idea how create such a formula...
Any ideas?
Thanks,
Matt.What is your Database?
Write a Stored Procedure having the query group by Time and use that sp to design the report
No comments:
Post a Comment