Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Supressing a data column in Data reports
- Thread starter netizen
- Start date
Seems the easy way would be to test the condition and use the test to vary the SQL string that you use to pull the data.
Pseudocode only:
if a = b then
mystring = ""
else mystring = "phone, "
SQLstring = "SELECT name, " & mystring & "address FROM .... Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'
Pseudocode only:
if a = b then
mystring = ""
else mystring = "phone, "
SQLstring = "SELECT name, " & mystring & "address FROM .... Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'
- Status
Similar threads
- Locked
- Question