By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Access query - getting results

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.