I have a database that I have now made two queries to sort the data with two
different totals.(Example: Total classes - now sorted into finished and
waiting) At the bottom of my form I want three totals. Total classes(This is
fine-Count works) Total finished classes and Total waiting classes. I would
like to get the Total number from each Query for finished and waiting.(Count
does not work.) How?!?
--
Sondra Wilson
###########
so******@online.no
A smile travels faster
than a virus.
"Larry Linson" <la**********@ntpcug.org> wrote in message
news:fc**************************@posting.google.c om...
I'm a little confused as to what you have and where from this
question.
However, just guessing: perhaps you could use a DCount function as the
Control Source of a Calculated Control on your report to accomplish
your purpose?
Please follow up here in the newsgroup, not by e-mail. Thanks.
Larry Linson
Microsoft Access MVP
"Sondra Wilson" <so******@online.no> wrote in message
news:<L8********************@news2.e.nsc.no>...
I have created a sorted query. The total(records) I get in the query is
correct. My problem lies with getting that total into my report.
I use count to insert the total number of records in my
datasheet.(That's fine) My report also needs the number of records from the query. When I
use "Count", I get the whole datasheet and not just the "sorted query".
Is there any way to get the number that I need?
Any help is appreciated. Thank you.
