<html><head></head><body><div class="ydp8ffe7758yahoo-style-wrap" style="font-family:verdana, helvetica, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">That's the total number of records, including deleted ones.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Bill Lucca</div><div dir="ltr" data-setdir="false">Old Tappan Computer Consultants, Inc.</div><div><br></div>
</div><div id="yahoo_quoted_9683270694" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, December 23, 2020, 05:39:47 PM EST, Scott Walker via Filepro-list <filepro-list@lists.celestial.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">So my the logical next question....is that the number of actual used<br clear="none">records, or the total records in the file including deleted records that<br clear="none">have not yet been reused?<br clear="none"><br clear="none">Regards,<br clear="none">Scott<br clear="none"><br clear="none">Scott Walker<br clear="none"><a shape="rect" ymailto="mailto:Scott.walker@ramsystemscorp.com" href="mailto:Scott.walker@ramsystemscorp.com">Scott.walker@ramsystemscorp.com</a><br clear="none"><br clear="none"><br clear="none"><br clear="none"><br clear="none"><br clear="none">-----Original Message-----<br clear="none">From: Filepro-list<br clear="none"><filepro-list-bounces+scottwalker=<a shape="rect" ymailto="mailto:ramsystemscorp.com@lists.celestial.com" href="mailto:ramsystemscorp.com@lists.celestial.com">ramsystemscorp.com@lists.celestial.com</a>> On<br clear="none">Behalf Of WILLIAM LUCCA via Filepro-list<br clear="none">Sent: Wednesday, December 23, 2020 5:14 PM<br clear="none">To: '<a shape="rect" ymailto="mailto:filepro-list@lists.celestial.com" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>' <<a shape="rect" ymailto="mailto:filepro-list@lists.celestial.com" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>>;<br clear="none">Richard Kreiss <<a shape="rect" ymailto="mailto:rkreiss@gccconsulting.net" href="mailto:rkreiss@gccconsulting.net">rkreiss@gccconsulting.net</a>><br clear="none">Subject: Re: Drawing a blank<br clear="none"><br clear="none"> It's numrecs(lookup_file_name), so you can use n =<br clear="none">numrecs(lookup_file_name) and n will be equal to the number of records in<br clear="none">the lookup file or use - for the current file.<br clear="none"> On Wednesday, December 23, 2020, 04:01:18 PM EST, Richard Kreiss via<br clear="none">Filepro-list <<a shape="rect" ymailto="mailto:filepro-list@lists.celestial.com" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote: <br clear="none"> <br clear="none"> Is there a function or filed value that will give the number of records in<br clear="none">a lookup file.<br clear="none"><br clear="none">I think there is but can't remember what it the value is.<br clear="none"><br clear="none"><br clear="none">Richard Kreiss<br clear="none">GCC Consulting<br clear="none"><br clear="none"><br clear="none">-------------- next part --------------<br clear="none">A non-text attachment was scrubbed...<br clear="none">Name: winmail.dat<br clear="none">Type: application/ms-tnef<br clear="none">Size: 12448 bytes<br clear="none">Desc: not available<br clear="none">URL:<br clear="none"><<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20201223/e3" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20201223/e3</a><br clear="none">4bbbe5/attachment.bin><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"> <br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL:<br clear="none"><<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20201223/06" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20201223/06</a><br clear="none">d1ff56/attachment.html><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><div class="yqt7361133533" id="yqtfd69034"><br clear="none"><br clear="none"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div></div></div>
</div>
</div></body></html>