Now I got the hard question out of the way lets try this
Posted on 2006-07-09
I have learned how to get the sum of the total records in a query, now I need to know how to get the total for each record in a repeat region. my table has a total column at the end of each row. so with the query below how do I write it to give me the total for each record by its self.
By the way, I could have not even come close to building the database I have now if it wasn't for the help I have been getting from you all. I am forever greatful.
SELECT (paymaker_quanity * paymaker_unit_price) as Total
FROM paymaker, invoice_my_custom
WHERE userid = 'varuserid' AND pmdate >= 'varpmdate1' AND pmdate <= 'varpmdate2' AND company = Val('varcompany')