debbiecarvery
MIS
I would like to have:
rep Deposits balance qual confir sale contract
John 100.00 50.00 1 3 2 1
Mark 100.00 0.00 5 2 1 2
I have tried using a crosstab query and I am able to get the information I need on a regular query and a crosstab query. When I try to use info from both of these queries I am getting an error. Anyone with any ideas how to do this differently or how I can make this work ?
Thanks
Debbie
rep Deposits balance qual confir sale contract
John 100.00 50.00 1 3 2 1
Mark 100.00 0.00 5 2 1 2
I have tried using a crosstab query and I am able to get the information I need on a regular query and a crosstab query. When I try to use info from both of these queries I am getting an error. Anyone with any ideas how to do this differently or how I can make this work ?
Thanks
Debbie