view data on form

L

learningMikey

I have a main form where I want to display several statistics like total
number of clients in the database, total number of movies etc. All together
there are ten statistics. Each of these comes from single or multiple tables.
How can I best display this information? I had created ten text boxes but not
sure how to populate the information on form open event. Any help would be
appreciated.

PS. I know I cannot have tables as forms data source given all these
statistics are coming from several different tables. Some of them might be
connected with each other some might not have.

Thanks,
Mike
 
J

joel sitbon

Friend,

joel-ange sitbon has invited you to join GreenZap and get $50 WebCash to
spend online. Sign up for a FREE GreenZap account and get $50 to spend at
hundreds of the world's premier merchants, many of whom are offering
incredible upfront discounts. Click on the link below to go to GreenZap and
signup! All thanks to joel-ange sitbon.

It's Zappening in the GreenZap Storez.
http://www.greenzap.com/joel1962

If you do not want to receive these emails in the future click the link
below:
http://www.greenzap.com/optout_invite.asp
 
J

JethroUK©

I've just created a report with some 100+ statistics on

Take a look at the DSUM() function

it's slow - but it works with independ/any tables
 
Top