I have read some similar posts but couldnt find the answer to help me with the below...

I am trying to setup a query so if cells are filled in with a project title then only this data comes through the database query, if it is empty - everything comes through.

So i did:

Criteria field = Project
Value = Is Not Null
or = [Project Title]

I know this isnt the right thing to do but i cant get it to work using other attempts...

So in the spreadsheet, if A1 = blank then all projects otherwise only what A1 equals. I can do the pointing to the cell easily, its just the IF statement in the Database query i am struggling with.