If Statement in Database Query

P

pmcook1979

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

I am trying to setup a query so if cells are filled in with a projec
title then only this data comes through the database query, if it i
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 usin
other attempts...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Multiple IF Statement in Word 5
IF Statement Table Help 1
IF statement not returning correct answer 3
IF AND Function Date Range Issues 6
If & Vlookup statement 3
Multiple VLOOKUP in an IF statement 2
somewhat complex if statement help PLEASE!!!! 1

Top