Runing multiple cryteria Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to run A delete Query Based on a People from Iowa Born before
09/06/1962

Do i have to use any SYntax for calculating this query because it keeps on
deleting everyone born in Iowa Rather that Those Born on 09/06/1962
 
Lucian,

The following will delee all records for people born in Iowa before (but not
on) 09/06/1962.

DELETE * FROM tblMyTable
WHERE State = "Iowa"
AND DOB < DateSerial(1962, 09, 06)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
On Sat, 28 Apr 2007 18:56:01 -0700, Lucian soldier <Lucian
I want to run A delete Query Based on a People from Iowa Born before
09/06/1962

Do i have to use any SYntax for calculating this query because it keeps on
deleting everyone born in Iowa Rather that Those Born on 09/06/1962
Click to expand...

Sounds like you're using OR logic. See Graham's SQL suggestion.

We can't see your database, don't know your table or fieldnames, and don't
know what you tried. Perhaps you could open your Query in SQL view and post
the SQL text here, and/or describe how you set it up in the query grid.

John W. Vinson [MVP]
 
Back
Top