2 queries plus a form

message from Alex on 16 May 2004

Hi anyone.
Please, give me some ideas how to do it...:(

I have a query : the result - the invoices info including
the invoice date.
On the date field there is some criteria: Between #some
date from form field1# and #some date from form field2#

There is a second query based on the first query:
This one just sums the data chosen based on date criteria
in the first query.

Then on the form based on the second query I have to
display the total result.

In short: form provides the criteria for the first query,
which is the source for the second query, which is the
source for the form itself..... :)

The problem:
I can run the second query separetely and it shows the
result, but the form refuses to show the result, does not
matter what refresh methods I am using.
Seems to me that there is something with the sequence of
retrieving the data....ANY IDEAS???
Or may be somebody knows how to do what I am trying to do
easier?

Thanks.

tina replied to Alex on 16 May 2004

if the form is based on Query2, then i assume your BeginDate and EndDate
controls are unbound? after you enter the dates on the form, Refresh or
Repaint will not work - but Requery should.
btw, why use two queries? have you tried turning Query1 into a Totals query?

hth

"Alex" <anonymous@discussions.microsoft.com> wrote in message
news:dd4801c43b7d$060024c0$a301280a@phx.gbl...

Alex replied to tina on 16 May 2004

Hi Tina,

Yes I have tried it to turn into a total query. But
Because I need the date for choosing the invoices, total
on invoices can not be done. There is a different date on
each invoice. Only the second query can to totals, after
the first one chose the necessary invoices..
This is why I am using two queries.

About requery. Dont work.
if I put just regular dates into the first query all
works fine, but as soon as I try to use as a creteria the
data from the form fields..nothing is showing..

Anyone? Ideas? I feel I am doing something wrong..Can
that creteria thing be done differently??!?

thanks.

BeginDate and EndDate
form, Refresh or
into a Totals query?
including
criteria
query,
not
of

Archived message: 2 queries plus a form (MS Access Database)