Iif Statement

T

Thorson

I am trying to write an Iif Statement for a query but I am not sure how to do
it. I have two tables in my query, one for the dam (mother) and one for the
sire (father). I want it so that if the color of the dam and father both =HB
then the column will put HB otherwise leave blank.
 
J

John Spencer MVP

Probably something like the following

IIF([TableNname].Dam="HB" and [OtherTable].Sire="HB","HB",Null)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
T

Thorson

Works great! Thanks
--
Thorson


John Spencer MVP said:
Probably something like the following

IIF([TableNname].Dam="HB" and [OtherTable].Sire="HB","HB",Null)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I am trying to write an Iif Statement for a query but I am not sure how to do
it. I have two tables in my query, one for the dam (mother) and one for the
sire (father). I want it so that if the color of the dam and father both =HB
then the column will put HB otherwise leave blank.
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

Limit Combo Box records in Table/form 6
IIF statement to compare two fields. 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Iif then statement needed for Access 2007 please 5
Using an IIF Statement to calculate discharge date 4
IIF function, multiple IIF 0
Nested IIF Statement in a query 4
IIF statement 6

Top