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

John Clark John.Clark at niagaracounty.com
Thu May 13 09:11:26 CDT 2004


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



More information about the AccessD mailing list