[AccessD] How to - get a count for a condition

Jim Hewson JHewson at karta.com
Thu May 13 09:22:14 CDT 2004


I would count the records in the query.
If you know the number of records in the datasheet view of the query, a count using either another query or DCount function would give you the results to need.
HTH
Jim
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Thursday, May 13, 2004 9:11 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] How to - get a count for a condition


I thought this would be simpler, but...I need to get a count for records
logged in a given time period, and I seem to be at a loss. Basically, I
have a field called 'datLoginDate' and I want to find all records
'logged' during a period, which I will get from a 'BegDate' and an
'EndDate' on the form.
 
I first thought they wanted a list of the records, so I have a query
already that finds these records. And, I know from running the query,
how many records exist. But, how do I just get the number?
 
This program is A97, but I am moving it over to A2K soon, so a solution
for both would be great.
 
Thanks!
 
John W Clark
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list