Delete info from a query? (1 Viewer)

Hi all,

Okay I have 2 tables and I used queries to filter and delete the info off those tables. Now I combined the 2 tables by using a query which is query 1. What I found was a few cells that are blank cells.

I tried creating another query based on query 1 from the 2 tables to try and delete it but it won't work. I tried everything and nothing seems to work. I can't filter the data since I am creating another query called query 3 to display the final results.

Any ideas on what I should do?

Could you explain it on a different way what you want to preform?

JHB said:

Could you explain it on a different way what you want to preform?

Click to expand...

I am trying to use a query to remove blank cells that were created from another query. When I use the delete button at the top of the console screen for a delete query, it wont work. I tried using "" and Is Null but it neither work or gives me an error.

I need to remove the blanks on the created query so I was trying to use a another query to remove the blanks but nothing seems to work.