Hello, I've created a query (QRY_Neg-Totals) which total a number of table columns (Proposals-Table). One column is all the elements of the proposal (e.g. Labor, Materials, TotalCost, Profit, TotalPrice, etc) another column is what was negotiated (e.g. Labor, Materials, TotalCost, Profit, TotalPrice, etc). I need to export to Excel a report with column heading of "Proposed"and "Negotiated" (I have multiple additional columns needed but for simplicity only listed two) and with cell A2="Labor", A3="Materials", A4="TotalCost", B2="ProposedLabor", C2="NegotiatedLabor", etc...
How do I SELECT the query for this report and how would I assign each cell with the correct values. I've looked everywhere but have found nothing. I would have created a separate table for this but the table won't allow me to use the formulas I needed to derive my totals (multiple Sum IIf statements).
How do I SELECT the query for this report and how would I assign each cell with the correct values. I've looked everywhere but have found nothing. I would have created a separate table for this but the table won't allow me to use the formulas I needed to derive my totals (multiple Sum IIf statements).