Search results

This question seems so basic I'm apologizing before asking. I'm sorry for being so dumb! I have a basic select query that searches for "ABC Learning" there are 4 in the table. How do count the total of these? I thought I just put 'count' in the total field but i keep getting an error! Whats...

Hello All, Is it possible to generate a query that can calculate the 'TotalMins' that an event covers our peak times? I.e. Our peak times are 0700 to 1000 if we have a start time of 0600 and a finish time of 0900 is it possible for the query to work out that we have covered 120 mins of the...

Hello, I have been trying to get 'TotalMins' field to calculate to total minutes between 2 time fields 'StartTime' and 'FinishTime'. All the update queries i make only seem to adjust the underlying date. I have been advised that i will have to have both the date and times in the field,but this...