Cascaded queries

[Colin Hammond]

I need to produce a list of club members that had renewed their membership
by a certain date and exclude those who joined after this date. OK easy so
far, but I need to then say how many are family heads and how many are
spouses, cadets, etc. requiring further queries based on the first query. Is
there some way the first query can form a temporary table so that I don't
have to type in the date criteria several times to get the numbers I
require.

Colin

 

[Guest]

Create a form not linked to any table (AKA unbound form) named frmSearch. On
this form put a text box named txtMembershipDate. Also put a button on the
form that will run the query. The Command Button wizard will guide you
through it under Miscellaneous, Run Query.

In the queries put something like the following in the appropriate criteria
boxes:
< [Forms]![frmSearch]![txtMembershipDate]

You put the dates in the form and then run the query. The form needs to stay
open; however, it could be minimized or even hidden. As long as the form is
open, you could run multiple queries based on the data.

 

[Santos M.]

I need to produce a list of club members that had renewed their membership
by a certain date and exclude those who joined after this date. OK easy so
far, but I need to then say how many are family heads and how many are
spouses, cadets, etc. requiring further queries based on the first query.
Is there some way the first query can form a temporary table so that I
don't have to type in the date criteria several times to get the numbers I
require.

Colin