Total Number of Appts

[Online Premium Trading]

Greetings;

I have a database that has the following information stored

* Full Name

* Street Address

* Surburb

* Home Phone Number

* Mobile Phone Number

* Number of Time Called

* Call outcome

What i want to do is make it so that up the top it will count the number of records that have the Call outcome of "WARM" for today and also for the week.

Sounds simple, but i cant seem to get it working

anyone have any ideas ?

[Angus Cameron]

To start with you will need to store the call date on each record. Presumably you will store just the last date called. There will be two additional calculations: Day_called [DayOfYear(Call Date)], Week_called [WeekOfYear (Call Date)].

You don't say how you are going to specify the day and week number at the top. If you are happy to summarise the totals to show on only Warm calls made on the same day as the record you are viewing then it can be a simple self join: Call outcome to Call outcome and DayOfYear to DayOfYear. If you want to be able to specify a day/week you might create some global fields as the parents of the join: The fields being Call_Quality (Global, contents "Warm"), Date_specified (Global), Date_specified_Day (Global calc), Date_specified_week(Global calc). Then add the first two Globals to the top of the layout and create the relationships Call_Quality to Call Outcome AND Date_specified_Day to Day_Called. Same for Date_specified_week to Week_called. Call the relationships: Data_Data_DayOfYear and Data_Data_WeekOfYear

Finally, you have two more calculation fields: Count( Data_Data_DayOfYear::CallQuality )& Count( Data_Data_WeekOfYear::CallQuality ) These will accumulate totals for the two relationships.