Maybe these more detailed instructions will help.
Based on what you've said, I assume you have a table named "Your Table" with
three fields named "field1", "field2", and "field3" and one record. For
example, let's say your table looks something like this:
field1 field2 field3
a b c
Try the following:
1. Create a new query in design view.
2. In the Show Table dialog that appears, choose Close.
3. From the View menu, choose SQL View.
4. In the SQL window that appears, replace whatever text shows up by
default with the following, substituting the text "Your Table" with whatever
the name of your table is:
SELECT
[Your Table].[field1] AS [Your Field]
FROM
[Your Table]
UNION ALL SELECT
[Your Table].[field2] AS [Your Field]
FROM
[Your Table]
UNION ALL SELECT
[Your Table].[field3] AS [Your Field]
FROM
[Your Table]
5. From the View menu, choose Datasheet View. You should see the results
of the query that look something like this
Your Field
a
b
c
Dan said:
i changed my query to an sql but that didnt seem to do it
i only have one record in my database the data is still
going across the top i tried putting Union in front of my
data but it doesnt work ? im confused
-----Original Message-----
Use a union query. The SQL might look something like this:
SELECT
[Your Table].[field1] AS [Your Field]
FROM
[Your Table]
UNION ALL SELECT
[Your Table].[field2] AS [Your Field]
FROM
[Your Table]
UNION ALL SELECT
[Your Table].[field3] AS [Your Field]
FROM
[Your Table]
Check the "UNION Operation" help topic for more information.
is there a way to make your data in a query go down
instead of across
field1 field2 field3
field1
field2
field3
.
