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

Display number of records in a query on a form

P: 2
Ok maybe i'm stupid because i want something really simple and can;t figure it out.

I would like to display the number of records in a query on a access form.

To be precise i made a database for printing c-cards and would like a form displaying how much of which cards are waiting to be printed. I can calculate the number of records by creating a total query, but can't display the result on a form.

Any ideas anyone?

thanks in advance,

Button
Apr 19 '07 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,638
Ok maybe i'm stupid because i want something really simple and can;t figure it out.

I would like to display the number of records in a query on a access form.

To be precise i made a database for printing c-cards and would like a form displaying how much of which cards are waiting to be printed. I can calculate the number of records by creating a total query, but can't display the result on a form.

Any ideas anyone?

thanks in advance,

Button
'For a Count of Records returned from a Query, you can place the following line of code in the ControlSource of a Text Box:
Expand|Select|Wrap|Line Numbers
  1. =DCount("*", "<your query name>")
Apr 19 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
Spot on to the last detail :)
Apr 25 '07 #3

P: 2
So i was stupid that i didn't figure that one out. ;-)

Thanks a lot guys.
May 3 '07 #4

NeoPa
Expert Mod 15k+
P: 31,494
So i was stupid that i didn't figure that one out. ;-)

Thanks a lot guys.
I wouldn't say that. it all depends on what you knew and didn't use.
But that's what we're here for :)
May 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.