Sorting form by a feild value in a table

[zippy483]

Hi all I have the following question



I have a table that stores data adn one of the fiels values is direction x or y so we have

|field 1|field 2|field 3|direction|field 4|

for example

direction x and y will be different records in the parent table

and I want to arrange my data on a form as so

| direction x | direction y |
|field1|field2|field3|field1|field2|field3|


any ideas

Many Thanks Zippy483

[ranman256]

A crosstab query may do this.
Click new query button, select the crosstab wizard, follow the instructions.
for the last choice VALUES, select FIRST (not sum, or avg)

This may flip the data how you want it.