simple count

[Scott Walker]

If you just want a count, do an output process-only format.
 
In sort/select processing, select only the records in file A that have a
status of "10"
 
In output processing, do a lookup to file B to see if date is le 3 years
ago.
 
If it is, increment a counter variable, if not, just end.
 
 
When the last record is processed, show the Total on screen.
 
 
Regards,
 
Scott
 
 
Scott Walker
RAM Systems Corp.
ScottWalker at RAMSystemsCorp.com
Ph: (704) 896-6549


-----Original Message-----
From:
filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celest
ial.com] On Behalf Of scooter6 at gmail.com
Sent: Thursday, June 12, 2008 3:27 PM
To: filePro Mailing List
Subject: simple count
 
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/19c09783/attachment-0001.html