simple count

[scooter6 at gmail.com]

I have filePro 5.0.9 on SCO Unix.

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.

After being up most of the night dealing with some other work issues, my
brain is a little mush right now.

Can someone point me in the right direction on quickest way to do this?

thanks

Scott Ullmann
scooter6 at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080612/6ba0fc4e/attachment.html