Simple Select query

[sandlucky]

My Query>

SELECT Genus, Species
FROM Main

In above query I get Genus, Species in 2 columns, But need them
to appear in 1 column.
(Need both Genus and species names to apear in only 1 column)

Pls help,

[sabre]

SELECT [Genus] & " , " & [Species] AS [Genus and Species]
FROM Main;

[sandlucky]

Cool,
V. simple.
I got what I expected.
Thanxalot! TC

[sandlucky]

Pls can u giv me lil help,

Consider query

SELECT
[Genus] & " " & [Species]&" is commonly known as "& [Sinhala1] & " in Sinhala. These "&[GrowthDuration]&" "&[Habitat]&"s"&" mainly grows in "&[Ecosystem]&" ecosystems of "&[climaticzone]&" of Sri Lanka." AS [Details]
FROM Main
WHERE ID='01'
It gives output>

Ixora coccinea is commonly known as Rathmal in Sinhala. These P Bs mainly grows in TT ecosystems of WID of Sri Lanka.

I have separate switch functions to decode abbriviates (P,B,TT,WID)
ex: P means Perranial (Growth Duration)
Growth Duration ha 2 types (P=Perrinial, A=Annual)
In below query switch function, I use it to Decode orginal words (Annula, Perannial)
insted of Abbriviates (P,A).
Switch(Main.GrowthDuration='A','Annual',Main.Growt hDuration='P','Perennial')

But I need to combine these 2 queries, can u help me 2 solve this