Newb needing the Results from 3 fields matching from query.
Posted: Wed Oct 18, 2006 11:18 pm
Could someone give me advice on how I would query the database and present only the results that matched my criteria? Example:
Database: Office
Table: AForm
Feild1: TechName (Steve)
Feild2: DateRecordEntered (Today)
Field3: ClientName (Brown Inc.)
MoreFileds…..
I want to find only the records that match all three search criteria Steve, Today, and Brown.
Thanks for your help!
Database: Office
Table: AForm
Feild1: TechName (Steve)
Feild2: DateRecordEntered (Today)
Field3: ClientName (Brown Inc.)
MoreFileds…..
I want to find only the records that match all three search criteria Steve, Today, and Brown.
Code: Select all
SELECT TechName, DateRocord, ClientName, MoreFields... FROM AForm
WHERE TechName='$name', DateRecord='$date', ClientName='$client'