Lookup Invoice by total amount

[SAC]

I just posted a question about how to retunr a value from a sql statement,
but maybe there's a better way.

I'm trying to lookup an invoice number based upon entering the total amount
of the invoice. Of course I don't store the total amount as it's calculated
so I'm think I would need to run a query summing the amounts to get the
total and return the invoice number so it can be looked up.

Is there a better way?

Also, how do I retunr the invoice number from such a sql statement so I can
look it up?

Thanks.

 

[Stockwell43]

Hi Sac,

Unfortunately, I can't help you with SQL as I know very little to nothing
about it. However, You do know you can use the find feature in the Edits menu
right? You can even create a button on your form through the wizard for this
function. Also, wouldn't it be easier to search by the invoice number versus
the total amount? You should one have one unique invoice but you could have
several records with the same total amount. Just asking is all.

Hope this helps!!

 

[SAC]

Thanks, but there's a couple things to think about...

The total amount of the invoice is not stored, but is calulated as is good
db design, so it's not just a number to lookup with find.

Since the customer wants to search by invoice amount, serching by invoice
number would not satisfy them. Sometimes their customers send in a check
and they are attempting to match the check with an amount of an invoice, so
I want to show a list of all invoices for that amount that are unpaid.

Hope this helps.

I appreciate your input.