I have the following query.
SELECT [tbl 572 Group Home Analysis].[PT-Patient Group], Sum([tbl 572 Group Home Analysis].[TX-Acq Cost]) AS [Total Acq], Sum([tbl 572 Group Home Analysis].[TX-Price]) AS [Total Price], Count([tbl 572 Group Home Analysis].[TX-Rx Number]) AS [# of RX's], Sum([tbl 572 Group Home Analysis].[$ Margin]) AS [$ Margin], [Total Price]/[# of RX's] AS [Avg $ per RX], [$ Margin]/[# of RX's] AS [Avg Marging per RX]
FROM [tbl 572 Group Home Analysis]
GROUP BY [tbl 572 Group Home Analysis].[PT-Patient Group], [Total Price]/[# of RX's], [$ Margin]/[# of RX's];
When I run the query it prompts me for [Total Price], then for [# of RX's]. If I hit enter past each one it runs and the results are what I want. How do I get it to stop asking me for those values and just run the query?
The table is created from a Make Table query if that matters.