"From" in Delete row of Delete qry

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
 
M

[MVP] S. Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top