468,136 Members | 1,485 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,136 developers. It's quick & easy.

Access query - getting results

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.

--
Sondra Wilson
###########
so******@online.no

A smile travels faster
than a virus.
Nov 12 '05 #1
4 8139
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.

Nov 12 '05 #2
PPK

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

--
Sondra Wilson
###########
so******@online.no

A smile travels faster
than a virus.

Go to: http://www.mvps.org/access/
Best Regards
Petra Klatt (MVP)

Nov 12 '05 #3
On Sat, 30 Aug 2003 21:35:26 GMT, "PPK" <PP*@hotmail.com> wrote:

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

--
Sondra Wilson
###########
so******@online.no

A smile travels faster
than a virus.

Go to: http://www.mvps.org/access/
Best Regards
Petra Klatt (MVP)


Nov 12 '05 #4
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Frnak McKenney | last post: by
4 posts views Thread by Orion | last post: by
11 posts views Thread by Randy Weber | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.