Number of Days?

[Laurie]

I have searched the posts and have not been able to find a resolution that
would help me with an issue I am having.

I have a field named "Decision Date" and in my query I have the criteria set
for this field as [BEGIN DATE (mm/dd/yy)?] And [END DATE (mm/dd/yy)?] so
that I can pull records between two dates. On my report I have the control
source for this Decision Date field set as: ="For the period: " & [BEGIN
DATE (mm/dd/yy)?] & " thru " & [END DATE (mm/dd/yy)?]. I have another field
named "Approved" which contains a number (i.e. 19).

In my report I want to have a field named "Average Weekly Approved" which
would be based on the "Decision Date" field and the "Approved field" . I
have set the control for the "Average Weekly Approved" field to: =([Sum Of
Apporved]/[NumberDays])*7). I tried putting an unbound text box on the
report to get the number of days from the "Decision Date" field and have
tried using date diff("d",[End Date],[Begin Date]) but it does not work.

How do I set a text box to count the number of days based on the "Decision
Date" field?

Hope I have adequately explained what I am trying to do. Any help would be
appreciated.

Thank you,

Laurie