Forum     

Go Back   Digit Technology Discussion Forum > Portables, Peripherals and Electronics > QnA (read only)
Register FAQ Calendar Mark Forums Read

QnA (read only) Mods please help transfer the contents of this forum to proper sections. :)


 
 
LinkBack Thread Tools Search this Thread Display Modes
Old 30-11-2006, 01:08 PM   #1 (permalink)
Apprentice
 
Join Date: Apr 2006
Posts: 69
Default Counting Records In A Report In Ms Access


I would like to count the number of records in a report formed from a query. I am getting "#Error?" message. I have entered control source property of the text box to Count(*) and am using MS Access 97. Kindly help.
kisorgovinda is offline  
Advertisements. Register and be a member of the community to get rid of them.
Advertisement

Old 01-12-2006, 02:07 AM   #2 (permalink)
Coming back to life ..
 
it_waaznt_me's Avatar
 
Join Date: Nov 2003
Location: A bit closer to heaven
Posts: 1,997
Default Re: Counting Records In A Report In Ms Access

Hmm.. You should create a query like " Select Count(*) from Data ;" and save it. Now put the output of this value to be controlsource of the textbox.
__________________
Sleight of hand and twist of fate...
On a bed of nails she makes me wait...
And I wait without you ...
With or without you ..
----
Batty = Too Busy Now !!!
it_waaznt_me is offline  
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Latest Threads
- by Charan
- by clinton
- by Krow
- by clmlbx

Advertisement




All times are GMT +5.5. The time now is 11:41 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.

Search Engine Optimization by vBSEO 3.3.2