G goju Registered User. Local time Today, 17:06 Joined Apr 7, 2005 Messages 77 May 13, 2005 #1 i am trying to count the number of records based in a query can some one send me in the right direction
i am trying to count the number of records based in a query can some one send me in the right direction
FoFa Registered User. Local time Today, 11:06 Joined Jan 29, 2003 Messages 3,672 May 13, 2005 #2 Select count([somecolumn]) from {table or query name}
neileg AWF VIP Local time Today, 17:06 Joined Dec 4, 2002 Messages 5,975 May 13, 2005 #3 Or if you don't speak SQL, click the sigma button on the toolbar in QBE view to create a totals query, and select count on one of the columns.
Or if you don't speak SQL, click the sigma button on the toolbar in QBE view to create a totals query, and select count on one of the columns.
