help;

[Guest]

I have a query (date, department, total) that calculates the total number of
hours for each department. Although department isn't quite the right field to
use (I need to use something similar) it will suffice for now.

The part of the business I work for does enquiry work and I need a way of
entering the total number of answered enquiries into a form (I don't have the
table yet) that can be directly related to the appropriate department. From
this I can calculate productivity.

I have a switchboard form for producing reports based on dates. I would like
to be able to click on a button that will open a form so I can enter the
total number of enquiries. Can a query of this type be used as a partial
source of information for entering data into a form?

If clarification is required let me know and I am open to ideas.

 

[Guest]

Having thought about it, I don't need to calculate the totals in a query for
a specific date. I can calculate totals for every date and then enter the
enquiry volumes as appropriate.

How can I summarise information from a table in a form (using field controls
I presume) using a particular date as a filter (so when the record changes,
the date and the totals change)

cheers