Search results

I created a report with a border and a watermark logo in the center of the page. The fields on the report is too much for one page. Is there a way to have the border and logo shown on the other pages? i.e. the border and logo is only shown on Page 1 Also is there a way to format the fields...

I was just using "first" as an example. If there are 5 debits and 3 credits then I want to match the 3 credits to 3 debits and not apply the 3 credits to all 5 of the debits. Is that possible? This entire scenario is very rare.

My apologies for not making myself clear. What I am trying to achieve is NOT to have on my Client Statement report (by client) records where debits and credits can be matched and removed from the report as clients find it confusing. For example, I don't want to see say Amount Inv. No...

How can I use Find First in the query below? SELECT Pos.osamt, Pos.ClientNo, Pos.FirstName, Pos.LastName, Pos.Address1, Pos.Address2, Pos.City, Pos.Country, Pos.TransDate, Pos.InvoiceNo, Pos.PolicyNo, Pos.TransAmt, Pos.TaxAmt, Pos.ReceiptAmt, Pos.Currency FROM Pos LEFT JOIN Neg ON (Pos.osamt =...

In response to KeithG's question, I am using it based on results from a query

Is there a way in a query (using SQL) to go to the first record to update a field based on a criteria ? For example if my amount field shows two amounts for $300.00 I want to go to the first record that has $300.00 to update a field in that record. Is that possible?

How do I adjust the SQL query below so that if the client has 2 or more debits for the same amount say in the example below $1,272.00 and the client has 1 credit on their account for ($1,272.00), I would like the credit to be applied to any one of the debits once the amount is the same. The...