if statements

G

Guest

I have almost cracked the IF statement but i am just inches away!

i have a query with the following fields

job title date in Placement ID Placed
PA 01/01/2007 -4001 YES

I want the field placed to show yes IF there is a placement ID example
(-4001) and if not show "not placed" please help! as the window is looking
very inviting
 
G

Guest

Excellent works a treat!

thanks

Rob Parker said:
Placed: iif(IsNull([Placement ID]),"Not Placed","Yes")

HTH

Rob

smason said:
I have almost cracked the IF statement but i am just inches away!

i have a query with the following fields

job title date in Placement ID Placed
PA 01/01/2007 -4001 YES

I want the field placed to show yes IF there is a placement ID example
(-4001) and if not show "not placed" please help! as the window is looking
very inviting
Click to expand...
Click to expand...
 

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

count by month 1
if statement 1
Report calculation 2
counting and placing answer in text box 6
Complex query 4
Expression / SQL Statement Help 9
getting top result for only some records in a query 5
Query Criteria IIf statement 4

Top