make data go down instead of accross

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

is there a way to make your data in a query go down
instead of across

field1 field2 field3


field1
field2
field3
 
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.
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top