Need some help with a Query.

[tamer64]

I have a query which is pulls data from one table called "Employee_Info". Table consist of the following:

EmpID
Date
LName

The query I have displays the information like this:

EmpID Date LName
2134 1/24/2013 John Doe
3443 2/14/2013 James Frank

Is it possible to have the query display the info like and if so how is this accomplished?

EmpID Date LName EmpID_1 Date_1 LName
2134 1/24/2013 John Doe 3443 2/14/2013 James Frank

 

[lameid]

No. There is something called a crosstab query that will let you use a single column's values as column headings but that is as close as you'll get with a query.

Unless you just want two sets of the same columns and not everything accross... you could play a game with using a non-Equijoin... In which case you'd need sequenced data with no gaps.

But if you just want to display data, use a report and turn columns on. Just remember to keep the width narrow so multiple columns will fit on a page.

If you want everything accross, your best bet is to dump it to Excel, and find a method to do it in there. I know they exist I just don't remember any of them without the internet

 

[dhookom]

You could first create a ranking query so the records are numbered. You can then create a crosstab query that uses the number ranking in the column heading.

Duane
Hook'D on Access
MS Access MVP