Eliminate some fields but not record in report

Topic

New Reply

Would like to list all records but if a boolean field is true not show certain fields such as address, city, state, zip. I can barely get started with this for this is what I have:

SELECT Lastname, Firstname, NoAddress, Address, City, State, Zip
FROM Members
WHERE IIF(NoAddress,”, ”)
ORDER BY Lastname

NoAddress is the boolean.

Reply | Quote

Replies

First, are you doing this in Access or SQL Server? If it is Access, the simplest way to do this is a series of IIF() expressions that check the status of the boolean field. If it is true, then you can display either a Null value, or an empty text string (“”). If it is SQL Server, TSQL makes this a fair bit more complicated, as you have to use CASE statements. Hope this helps – if you want more advice on the syntax, post back and I’m sure someone can assist you.

Reply | Quote

Thanks for the reply. The light just went on with your suggestion. I was trying to do it with only one conditional statement and in the WHERE portion of the SELECT statement. It has to be with each field that is affected.

Reply | Quote