Make Column Show True False in Table

[lkdcox]

Hi there!

I am new to the forum. I was just wondering if you can make a column show true or false in a table when two other columns in the table match each other? I think the statement would be like this:

If([Column1] = [Column2], True, False)

The only problem I am having is that I don't know if it can work in a table or does it just have to be in a query?



Thanks

[June7]

Cannot do that in table in Access 2007 database. Calculate in query.

[lkdcox]

Ok can you show all the data from a table in a query?

[June7]

Of course.

Use the query builder. Pull whatever fields you want down to the grid. Or use the * wildcard to pull them all in one shot. Create another field with your calculation. The result could be like:

SELECT *, IIf([Column1] = [Column2], True, False) AS IsMatch FROM tablename;

[lkdcox]

ok that is close to the answer but not quite or maybe I am not entering it right. So I have created the query using my table data with the *. Now If i make a seperate column (column 3) in the query and try to use two columns from the table (ie. Column 1 and Column 2). How would I make that Column 3 reads:

IIf([Column1] = [Column2], True, False)

[orange]

What are the fields in your table now. You would not normally have a separate field in a table for this calculation.
You would run a query when you need the value.
Also using
IIf([Column1] = [Column2], True, False) indicates a boolean/logical result.

If you want to see True or False in the output, you would use
IIf([Column1] = [Column2], "True", "False")

[lfpm062010]

oops, little late.

In design view, just type "IIf([Column1] = [Column2], True, False)" (without quotes).



If you need the literal "True" or "False", then you will need
IIf([Column1] = [Column2], "True", "False")

[lkdcox]

Oh thank you guys!! It worked!

[lkdcox]

Thank you Ifpm for the screen shot! That really helped