criteria for a query

[pedmd]

How would you write a query that will isplay a particular concentration based
on two crtiteria (ie drug name and weight)?
thanks

 

[Lynn Trapp]

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