I have created a query that contains the data that I need for a report. I would just like to use certain fields from the query. Would I need to create VBA coding to do this.
Query
Sales_D
Sales_I
Comm_D
Comm_I
When I place Sales_D on the report it reports two lines.
The total for Sales_D and Sales_I. I understand why because there are two rows in the query. And it is coming back with the information that I am asking.
Query
Sales_D
Sales_I
Comm_D
Comm_I
When I place Sales_D on the report it reports two lines.
The total for Sales_D and Sales_I. I understand why because there are two rows in the query. And it is coming back with the information that I am asking.