Delete Query

[Mohd Zeeshan]

Hi

I have two file "A" & "B" , i just want to delete some data from file "a" which is same in both file. please help to delete the data

 

[Khalid_Afridi]

Welcome to AWF,
Always post your queries in a right panel. for example in Introducing yourself you can introduce yourself, in Query you can post a question related to queries, Report for reporting. Tables for tables and so on.

Can you explain your queries further more what data you want to delete? File mean tables? Queries?. There is no file in access.
Access contains on objects i.e Tables, Queries, Reports, Macros, Pages, Modules...

 

[John Big Booty]

You could use the wizard to create a Find Unmatched Query then once the query has been built, open it in design view and change the criteria that will be Is Null to Not Is Null and then change the query to a Delete Query.

Important Tip; Make sure you are happy that the query is selecting only the records you wish to delete before changing it to a Delete query and running it, as there is no undo for a delete query.