G Guest Oct 4, 2005 #1 How would you write a query that will isplay a particular concentration based on two crtiteria (ie drug name and weight)? thanks
How would you write a query that will isplay a particular concentration based on two crtiteria (ie drug name and weight)? thanks
L Lynn Trapp Oct 4, 2005 #2 Select Concentration From YourTable Where DrugName = [Enter Drug Name] And Weight = [Enter Weight] -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
Select Concentration From YourTable Where DrugName = [Enter Drug Name] And Weight = [Enter Weight] -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
