A
Alex
I have a query containing table called 'sas' and query
called 'date' that are not joined. The 'date' query lists
dates that the user picks are aren't listed anywhere in
the 'sas' table.
In my new query I'm trying to count the number of records
in the 'sas' table whose 'rundate' < the date listed in
the 'date' query. The query is counting all records in
the table (like shown). How can I define in my new query
criteria to only count the records in the 'sas' table
whose rundate < the date field in the 'date' query?
Date Current Count Count I want
10/27/03 1609 501
11/3/03 1609 550
11/10/03 1609 620
11/17/03 1609 700
11/24/03 1609 820
Thank you for your help.
Alex
called 'date' that are not joined. The 'date' query lists
dates that the user picks are aren't listed anywhere in
the 'sas' table.
In my new query I'm trying to count the number of records
in the 'sas' table whose 'rundate' < the date listed in
the 'date' query. The query is counting all records in
the table (like shown). How can I define in my new query
criteria to only count the records in the 'sas' table
whose rundate < the date field in the 'date' query?
Date Current Count Count I want
10/27/03 1609 501
11/3/03 1609 550
11/10/03 1609 620
11/17/03 1609 700
11/24/03 1609 820
Thank you for your help.
Alex