Search results

Sorry pat if my "likes" gave you someting else, but for me as you said "that i have a language problem" my like is more than a word.. Ofcourse i thank all you guys here for helping me solving my db problems..

Indeed, i created a table as u suggested and it also solved the other post i posted regarding the totals. Thank you pat..

Thanks pat, i will try that.

Hi pat, Yes my commission is simple and straight forward.. 8% for freelance agents, 10% for broker house agents.

Dear All, I need help to my report, please see attached, (a query data source and the report). I could not get a correct total (Sum) of commissions as it sums up all the rows as displayed in the query.. "Sum" function is not giving the correct summation.. You can see on the query that it shows...

Yes.. it is always 8% & 10%..

Many thanks sir.. Solved.

Agent code will only be 1 or 2.. per contract. (1=freelance agent, 2=brokerhouse agent)..

TCP is total contract price.. Table involve is tblBuyer and tblAgent.. Link field is agtID (FKey to tblBuyer).

Dear all, Please help me to write an expression for a commision.. Scenario are.. Agent code=1 (8%) Agent code=2 (10)%) TCP = 550,000.00 I need to test if the agent code is "1" (550,000.00*. 8%) or "2" (550,000.00*10%).. Please i need help very badly. Thank you.

Hello, All the flaging is done manually after getting a feedback from agents.. Yes it includes those buyers as you mentioned.. But those having status "holding fee" 1 wk from the payment date and getting a feedback from agent, will be flag manually "forfeited".. Possible that same buyer will...

Dear sir, Can someone pls help me to write a "word" for a "number", like php.150 - (one hundred fifty).. Thank you.

Hi Gap42, The remarks is entered from a selection of a combo.. My data entry of buyer and their payments is a mainform and subform, so there is a link that identifies buyer and payments.. The main reason why i need this filtering is, i need to print those buyer (parcel of land/lot).. I need...

Hello gap42, Thank you for mentioning all of these scenario, as a newbie i have a very limited insights on the

Hi ebs17, thank you, i will try this one.. What if, i would add 1 more criteria from "remarks" like "holding fee" and "1st monthly payment".. How do i write..

Hi GaP42, Yes sir, i have payments table.. I can count payments each buyer using their ID's (manualy).. Am trying to use the 'count' from my query but i dont how to put something like criteria for the 1 payment and 2 payments.. The reason why i need to print this is, i wanted to send a...

Dear all, I have a struggle in filtering a buyer having a 1 or 2 number(s) of payments.. Appreciate any help. Thank you.

Thank you, it sorted out by bob fitz.

Thanks bob fitz..