create virual column with SQL

[Pieterrr]

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!

 

[Remou]

You could use a union query, though I am curious as to why you want to do this.

SELECT "male" AS gender
UNION
SELECT "female" AS gender

 

[Pieterrr]

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 becomse a mesh with "unused" tables

 

[Golom]

SELECT TOP 1 "male" AS gender From AnyTable
UNION
SELECT Top 1 "female" AS gender From AnyTable

 

[Remou]

Will you be using a form to present the data? I hope so, and a form is the place to show the choice of Male or Female. You can use a combo.

 

[maxhugen]

In your form, add a combobox 'Gender', and set it to:

Row Source Type: Value List
Row Souce: Male;Female
Limit To List: Yes

Max Hugen
Australia

 

[dhookom]

The only way "to make a boolean choice in my table where i can choose between male or female" is to have a real column/field that can be updated. You can't update a "virtual" column.


Duane
Hook'D on Access
MS Access MVP

 

[JoeAtWork]

Of cource i can make a table with male and female, but then my database becomse a mesh with "unused" tables

Add some enforced relationships between your "unused" tables and the main ones and you would have what I call "data integrity".

 

[Pieterrr]

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!