Anyone know how to do this?
Create a calculated query using the fields City, State, Address, Agent ID, Price and a field giving the agent a 7 percent commission on the price of the home.