spacepro Registered User. Local time Today, 20:42 Joined Jan 13, 2003 Messages 715 Dec 10, 2003 #1 Show No of Records in Report? Trying to count the number of records in report based on a query. Does anyone have the code to show the number of records in the query on the report. Many Thanks Andy
Show No of Records in Report? Trying to count the number of records in report based on a query. Does anyone have the code to show the number of records in the query on the report. Many Thanks Andy
S sdkramer Registered User. Local time Today, 20:42 Joined Mar 19, 2002 Messages 64 Dec 10, 2003 #2 =sum([column to count]) if you're trying to count a number field
S sdkramer Registered User. Local time Today, 20:42 Joined Mar 19, 2002 Messages 64 Dec 10, 2003 #3 =count([column to count]) if you're just counting the number of records to return.
spacepro Registered User. Local time Today, 20:42 Joined Jan 13, 2003 Messages 715 Dec 10, 2003 #4 Thank you, I knew it was something simple. Andy
S sdkramer Registered User. Local time Today, 20:42 Joined Mar 19, 2002 Messages 64 Dec 10, 2003 #5 no problem. I hope I haven't oversimplified your question. If I misunderstood or this doesn't work let me know. Thanks, Seth
no problem. I hope I haven't oversimplified your question. If I misunderstood or this doesn't work let me know. Thanks, Seth
