if statements

S

smason

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
 
S

smason

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

Issue in create a certain query 2
Report calculation 2
Complex query 4
counting and placing answer in text box 6
count by month 1
if statement 1
Expression / SQL Statement Help 9
Autofill query 0

Top