Simple Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sahafi - 10 Mar 2008 23:07 GMT

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.
--

Reply to this Message

Beetle - 11 Mar 2008 04:40 GMT

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

Signature

_________

Sean Bailey

> 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
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

sahafi - 12 Mar 2008 15:03 GMT

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

Thanks.

> 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
[quoted text clipped - 14 lines]
> >
> > Thanks.

Reply to this Message