simple count

[Bruce Easton]

GCC Consulting wrote Thursday, June 12, 2008 5:35 PM:

Walter Vaughan wrote Thursday, June 12, 2008 5:03 PM:
> > 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
>

Yeah even though I posted a sample selection and output
processing, I think it only fair to say that's exactly what
Marcia would do here if she was trying to get out a quick
number before killing much time or trees - a simple fpsql.

Bruce

Bruce Easton
STN, Inc.