Tosh
07-10-2003, 02:58 AM
I have a report based on the following query:
InterviewID:Autonumber,Primary Key;
InterviewDate:Short Date ,Criteria is Between [Start] and [End]
Name:Text
MandatoryReferral:Text,Limited by combo box to Y or N
In the report footer I want the following totals;
Number of Interviews Booked = Count Interview ID
Number of Mandatory Referrals = MandatoryReferral = Y
Percent of Mandatory Referrals = Mandatory Referrals/Interviews
I'm having problems with the mandatory referrals. I've tried using Dcount to reference the underlying query but it returns an error. I've narrowed down the cause of this to the [Start] and [End]criteria on the Interview Date field, as it all works fine if I remove these.
Any ideas on how to get the totals while still maintaining the flexibilty of setting the interview dates criteria? ? ?
InterviewID:Autonumber,Primary Key;
InterviewDate:Short Date ,Criteria is Between [Start] and [End]
Name:Text
MandatoryReferral:Text,Limited by combo box to Y or N
In the report footer I want the following totals;
Number of Interviews Booked = Count Interview ID
Number of Mandatory Referrals = MandatoryReferral = Y
Percent of Mandatory Referrals = Mandatory Referrals/Interviews
I'm having problems with the mandatory referrals. I've tried using Dcount to reference the underlying query but it returns an error. I've narrowed down the cause of this to the [Start] and [End]criteria on the Interview Date field, as it all works fine if I remove these.
Any ideas on how to get the totals while still maintaining the flexibilty of setting the interview dates criteria? ? ?