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 Chriss Miller 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. Pieterrr

    create virual column with SQL

    Thanx Golom, with: SELECT TOP 1 "male" AS gender From AnyTable UNION SELECT Top 1 "female" AS gender From AnyTable it work's!! I want to present the data in a form. But i also want that my table has the "right" value. Thanx everyone!
  2. Pieterrr

    create virual column with SQL

    It doesn't work in Acces, is there another way to do it? I want to make a boolean choice in my table where i can choose between male or female, the only way to do it (that i know) is to look the values up in a table. Of cource i can make a table with male and female, but then my database...
  3. Pieterrr

    create virual column with SQL

    Hello, I want to create a virtual column in SQL with two values. Like this: gender ------ male female I can create a column with one value with the statement: SELECT "male" AS gender Can someone help me? Thnx!

Part and Inventory Search

Back
Top