Sum based on a start date And End Date

[Fred's]

Hi Folks,
I have a problem which I'm hoping to solve with your help!.

I'm try to sum in the Page Footer of my report the appotments that are
only "Drop", but it dosen't seems to work.
I'm always get the total sum of whatever the appointment is drop or
not.
How can solve this problem?

Thanks for your help!

Here is the details of my database as today:

I have two tables in relation.

The first table is named: Containers. and contains these fields names
and Data types

ID - Autonumber (Primary Key)
Date - Date/Time
AppointmentTime - Text
Comments - Text
Drop - Yes/No
Local - Yes/No


The Second table is named: Appointments and contains these fields
names and Data types
ID - AutoNumber (Primary key)
RendezVousID - Number
Containers - Text
Seal Number - Text
Shoes - Number
Aldo - Number
Globo - Number
FeetFirst - Number
Transit - Number
Handabags - Number
Aldo1 - Number
NonAldo1 - Number
Accessories - Number
Aldo2 - Number
NonAldo2 - Number
Total - Number
MarchandiseReceived - Yes/No


From These tables, I made a form/Subform named: FrmApprointments which
include the form:Appointments and as a subform: Containers

Also, form the above tables, I made three queries named. Query1,
Query2 and Query3

the Query1 contain all fields from the Table: Containers as well as
the feilds Drop from table: Appointments with the criteria: "Yes".
Aldo the fields :Shoes, handbags and accessories have the following
formulas:

Shoe: (([Aldo])+([Globo])+([FeetFirst])+([Transit]))
Handbags: (([Aldo1])+([NonALDO1]))
Accessories: (([Aldo2])+([NonALDO2]))
Total: Sum(([aldo])+([FeetFirst])+([Globo])+([Transit])+([Aldo1])+
([NonAldo1])+([Aldo2])+([NonAldo2]))

And a report sorted as below:

Report Header :includes
a label control box with a the report title

Page Header: includes
labels control boxes with a the report title

Container Header includes:
Container information field and seal feild

Details section includes:
Shoes, Aldo, Globo, FeetFirst, Transit, Handbags Aldo1, NonAldo1,
Accessories, Aldo2, NonAldo2 And for these formulas for the following
text control box
Shoes =([Aldo])+([Globo])+([FeetFirst])+([Transit])
Handbags =([Aldo1])+([NonAldo1])
Accessories =([Aldo2])+([NonAldo2])

Page Footer includes:
The Sums' from the feilds of details section and a Grand total.

Report Footer includes:
Date and page numbers