AnsweredAssumed Answered

Displaying record counts (Part One Question)...

Question asked by netguykb on Nov 15, 2008
Latest reply on Nov 26, 2008 by netguykb

Title

Displaying record counts (Part One Question)...

Post

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!

Outcomes