simple count

[Walter Vaughan]

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>

--
Walter