Calc Invoices to Pay?

[Walter Vaughan]

Fairlight wrote

>I think you missed a critical part.  He's not just matching individual
>checque amounts, he's matching one sum against multiple cheques.  Please
>show me the SQL statement that would come even remotely close--because I
>don't believe it exists even in Oracle, much less fPSQL.
>  
>
Select * from invoice
where
    customer number is "what it is"
    and status_flag is "unpaid"
    and amount between "Low value" and "High value"
order by
    date

That should find the invoices that have not been paid that could 
accomodate a range, rather than a specific value.

Me? A selection set or table would be fine, but the reality is that 
there are a million more places to learn how to write a SQL query than 
how to use filePro's native tools. So if they are looking for 
information in ways that the system as configured does not supply, why 
not teach them to use a tool that leverages that pool of talent and 
available training.

It's all about the tools in the toolbox. Some make better hammers and 
some make better pry-bars.

--
Walter