multiple field index

[scooter6 at gmail.com]

I have created a file that can have up to 12 credit card transactions dated
today or in the future...

So each morning I want to send the current dated ones to be processed but
think I'm having a brain cramp on this...

I have 12 fields that are date fields (each shows as a1) Date of 1st Pmt
a1) Date of 2nd Pmt, etc...then each has it's corresponding amount....

How would I select records dated just today and grab the corresponding
amount for that date?

I have the index built and can search by that day, but do I need to 'step'
though each of the 12 dates and if it matches today grab the amount in the
amount field for that day?

I tried this and am exporting these records but it only exports the last
record it finds with today's date??

Scott
PDM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/a508c86c/attachment.html>