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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TerryGef

    Find all columns of a single row that are True

    Hi, George... The host server is running: "Windows Server 8, version 6". I had wondered if the case statements are the problem. This code I'm trying to run is on a website, I'm not sure if that is the issue either. The actual database that I am accessing is an Access 2000 .mdb But my...
  2. TerryGef

    Find all columns of a single row that are True

    okie-dokie... So, I tried both above examples and am getting a "Missing Operator" error. At this point, I am wondering if it makes a difference that this is SQL being used on the Internet compared to Access vb or whatever. Normally my SQL can be used anywhere, but I'm stuck. Thanks in advance...
  3. TerryGef

    Find all columns of a single row that are True

    Your post is right on to what I am looking for, but when I plug in the statement, I am getting a missing operator error. Here is my query: SELECT ID, case when FB_chk Then ' FB_chk=True' else '' end + case when TW_chk Then ' TW_chk=True' else '' end + case when PI_chk Then '...
  4. TerryGef

    Find all columns of a single row that are True

    Hi, Need help in an SQL problem: I have a table that has individual records, There are 29 fields. One is a unique ID, 14 are True/False and 14 are text. Using a query to find one record, I'd like the SQL to Display only the fields that are True. So, in an example: SELECT * FROM table WHERE ID =...

Part and Inventory Search

Back
Top