need to change Access query results formatting

[bchbus]

Greetings,
i am running a very simple query which will return 1 record. the record's
fields however are returned horizontally. I want them vertically.

I get:
Name Gender Age
mike male 50

I want:
Name Mike
Gender Male
Age 50

thanks,
bchbus

 

[John W. Vinson]

Greetings,
i am running a very simple query which will return 1 record. the record's
fields however are returned horizontally. I want them vertically.

I get:
Name Gender Age
mike male 50

I want:
Name Mike
Gender Male
Age 50

thanks,
bchbus

For what purpose? If it's to display on screen use a Form; if it's to print,
use a Report; if it's for some other purpose, please explain. If there are 10
records in your table now, do you want a query to return 30 records?