Recent content by smil27

Sorry to bother, can you elaborate on the above. I do not quite understand why these fields are repeating and why the table structure is incorrect? Thanks

Commissions stay same for the agents but change for each property so Property 1 -Commission = 6% of the selling price. It could then be 4 for the listing agent ( or 2% & 2% if there's a 2nd agent) and 2% for the selling agent. Each property entered into Table1 has an ID field which is the...

Thanks Bob, you are probably right but before I start over, I will lay out all the info. I have a table of all 30 agents in the office called Agents: ID | Agent I made a form to input each sale that contains the following fields: ID | Street Address | Selling Price | Commission % | Gross...

Hello, I have created a small database for a real estate office to show reports of commission for each agent and for the total office. Table1 has fields for sales, commission and who is the listing or selling agent or both. Field Listing Agent pulls form linked table with the list of agents...