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'