simple count

[GCC Consulting]

> -----Original Message-----
> From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
>
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On
> Behalf Of Walter Vaughan
> Sent: Thursday, June 12, 2008 5:03 PM
> To: filePro
> Subject: Re: simple count
> 
> scooter6 at gmail.com wrote:
> 
> > I have about 300,000 records in a file.  Each of these records has a
> > 'Status' field. (let's call this fileA)
> > There is also a way to 'view' a lookup when browsing fileA to another
> > file to see a date of incident.  (let's call this fileB)
> >
> > What I'm trying to do is get a count for all records that are in
> > status "10" and whose date in fileB is less than or equal to 3 yrs ago
> > from today.......
> >
> > I don't want a printout of all these records, just a count.
> 
> <tack type=opposite_from_-v_table>
> Acutally this type of data request is *exactly* what SQL is good at.
> </tack>


Yes and one could use fpsql for this type of reporting.

I do this a lot when client's call for a quick one time report.  I run
fpsql, I can see the report and if it is what they want, it is rerun to
print.


Richard Kreiss