"From" in Delete row of Delete qry

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

I understand how to use the "Where" option from the
dropdown but how would I use the "From" option in the
Delete: row of a Delete query?

Thanks!

Regards,
Razor
 
Suppose that you had a parent and a child table involved in the query.
Customers and Orders.

Suppose you wanted to delete FROM Orders any records WHERE Customer State =
"VA".
(Silly example I know, but stretch for me.)

Get it? (If not, I'll actually build an example, but won't if you got the
gist.)

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top