Hi i have 2 things i need help again on. i appreciate all what you guys done so far but 2 more things
I need to sum a total of percentages on a report, how would this be done?
i have filters running on my form which filter all callbacks between specified intervals i.e. 10-12, 12-2, 2-4 etc you click the relevant button i.e 12-2 and it bring all callback for that time...once someone takes ownership of that callback by inputting a 2 character intitial it gets taken out of the filter results upon next click. is there a way i can see a real time counter of how many records are left after someone takes ownership and it minuses 1 until all records have been cleared from the filter results?
sorry about that was an early start this morning
yeah a real time counter showing once someone takes ownership of the record it subtracts one off the counter of the results and keeps on counting down until all the filtered results have an owner?
hope that helps.
So how would the dcount function work?
as i have 5 buttons each with a different filter for the time specified i.e. 12-2pm,2-4pm,4-6pm,etc when a button is pressed it filters out the specified times and brings back all the records where the customer would like a callback at that time, how would i have a counter next to them showing the amount of records in the results before actually pressing them, i would then be able to see how many callbacks i would have for each interval.