Query (can We Divide)

[pukhton]

Need help in building a query.

I have a Main Table, and it has Colums (Medication_Name, Diluent Type, Total Dose, Concentration), now I want a query where I can divide (Total Dose/Concentration) and produce Total for each Diluent Type and Mediaction.

Please help.. :)

[pukhton]

Need help in building a query.

I have a Main Table, and it has Colums (Medication_Name, Diluent Type, Total Dose, Concentration), now I want a query where I can divide (Total Dose/Concentration) and produce Total for each Diluent Type and Mediaction.

Please help.. :)

thats what we have in Excel, but I want something like that in Access.

D5W D10W NSS None
Fentanyl 40.0 36.0 10.0 320.0

[pukhton]

here is my code... I am getting an Error under Result..any idea??

SELECT MainTable.[Medication Name], MainTable.[Diluent Type], (MainTable.[Total Dose]/MainTable.Concentration) AS Result
FROM MainTable;

[JKing]

What error are you receiving?