data type mismatch in criteria expression

[cochise]

Fields: sales, date, invoice, department

I have a query displaying total sales for each department by month. I also have made a Grand_Total query. I have subsequently been able to get a % of total sales by making a field: Sum ( [Sales]/[GrandTotal]) using Expression under Total. I also can get a count on invoices by importing the field in the query and setting the Total to count.

I cannot seem to get a % of # of invoices compared to Total# of invoices. Any suggestions?

 

[DoubleD]

You should create an expression dividing Total Invoices in your department query by your Total Invoices in your Grand_Totals query.

 

[cochise]

Are you saying that I need to have 3 queries?