Simple Form

[sahafi]

I'm new to this, and here's what I need accomplished.
I have a query with 20 + fields that I would like to show some/all fields on
a form. This is a production data organized by week, month, year,
productCategory, productCode, PoundProduced, etc. So I would like the user to
be able to select a year and productCtegory (may be another field), and the
total PoundProduced will be populated on the same form or on a subform. Just
one total number. Currently the data in the query is grouped and summed but
it will show on 100s of rows. Also this is a multi-year data. PoundProduced
is the only calcualted field in my query. How can I accomplish this?

Thanks.
--

 

[Beetle]

You'll need to set up a form with, for example, some unbound controls
where the user can enter criteria that can be used to limit the query
results. Allen Browne has a good example of this type of form (complete
with code) at this link;

http://allenbrowne.com/ser-62.html

 

[sahafi]

Thanks. I will look into that and let you know if it met my needs.

Thanks.
--