Displaying record counts (Part One Question)...
I have a CRM type database that allows users to create accounts, and assign themselves activities. I want to be able to do the following:
1) Display record count of all activities that the current logged on user has to complete for Today (= Current Date)
2) Diplay record count of all activities that the current logged on user has to complete for the Future ( > Current Date)
If no records are found then display 0 (IF Statement)
Not sure if I need to create a dynamic table to capture this information and then display it or can I add a field in one of the current tables to calculate this information. I beleive the first option is what I need to do considering their are relations ships built into the primary account table and the activitity table.
Any help would help. Thank you!