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.

Its ok - got it to work by doing:

Like [Project Title]

Then in the cell it is pointing at did an if statement there to say =if(a3="","%",a3)...

The % was the wildcard i needed.