I have a spreadsheet recording wheat coming into various stores for a number
of customers. All wheat coming into store is entered on one sheet and this
then fires through to the relevant store worksheet eg store 1, store 2 etc.

Under a column headed €˜date the date on which the wheat came into store is
recorded. I would like to be able to ask the database what wheat came in
between two date ranges eg. Between 01/07/07 and 31/07/07 and so on for each
month.

The records are not necessarily entered in date order as entries are made as
the paperwork hits the office.

Many thanks for any help.