Deleting a record

[alexc333]

Hi All,

I have a query set up but I don't want all of the content within the query. However, if I delete a record from the query it also deletes it from the table. How can I just delete it from the query?

Cheers

Alex

[khalid]

Hi Alex

Queries are nothing but recordsets from tables, If your query is based on the table, and if you delete a record from it, it would definately delete those records from the table.

What you want to delete? and why?

[alexc333]

Thanks for the reply khalid. For example on my query I have a list of all Cancer publications. However, some of them are not suitable as they might relate to childrens cancer, so I need to subtract them from the query.

How would I take out these records without deleting them tottaly?

[khalid]

You can just select those records from table which are required and do your calculation etc.

You can SELECT your desired records for analysis using WHERE clause in the SELECT Statement.

SELECT field1, field2, field3, ...
From YourTable
Where [field1] = [YourCriteria]

field1 will be your desired field which you want to Filter for your analysis.

Hope this make sence

[alexc333]

Too complex for me. I think I will create new fields as this will make the db better in the long term as well.


Thank You for your help.

[khalid]

What query you are using for deleting your records?
can you copy and paste your query here by just select the SQL of your query from the QBE (query by example) grid?

[khalid]

is the problem solved?

[alexc333]

Oops I thought I mark it as solved, done now