Recent content by MRSPK

Thankyou very much! Its now working a treat! I found similar directions online elsewhere, but setting the parameters had me stump as I had never used that before. Thankyou!!!!!!!!!!!!:) :) :) :)

Legendary!!!!!!!:) :) A crosstab query looks like it will solve all my stat problems! I have one that counts the events by date which is perfect, except I can't add a criteria that limits the dates i.e."Between [Start date] and [End Date]" Why won't access play nice!:mad: How do I fix...

I have got it to work by doing 2 queries, one to select the data I require from the table and a second one to count how many entries are in the first query. Is there any way I can do this in one query?:)

I'm getting "data type mismatch in criteria expression.". I have 'ABC Learning' as the criteria as I want to sort out all other entries and just count how many times 'ABC Learning' appears.

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

Thankyou EMP & gromit, Learning heaps here, Another question. If the peak times of operation are 0700 and 1000. Is it possible for access to count how many minutes was covered by the start and finish times? i.e values are StartTime - 0500 Finishtime - 0900 Can access...

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