HELP! Single Column Query Results to Flow Side-by-Side using MS Access (1 Viewer)

psimpson

Registered User.
Local time
Today, 07:18
Joined
Aug 1, 2007
Messages
40
There is a requirement to display the results (Tope 3 Dates to flow side-by-side) for a single column query in MS Access. The application was written in 2003, but has been converted to 2007.

Any help is appreciated.

Thanks.

psimpson
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 01:18
Joined
Jan 20, 2009
Messages
12,849
Your question is not very clear but it sounds like you might need a crosstab query.
 

ajetrumpet

Banned
Local time
Today, 09:18
Joined
Jun 22, 2007
Messages
5,638
There is a requirement to display the results (Tope 3 Dates to flow side-by-side) for a single column query in MS Access. The application was written in 2003, but has been converted to 2007.

Any help is appreciated.

Thanks.

psimpson
is this requirement by a human being? if not, then why do it? (just kidding, sort of). You can't do this in Access, but you CAN make a CT query like Galax had said. but of course, you just can't select a date field and tell it to display that horzontally. have you played with the crosstab wizard yet?
 

psimpson

Registered User.
Local time
Today, 07:18
Joined
Aug 1, 2007
Messages
40
No. Do you have any guidelines for creating a good CT query? The results continuously return "You can't specify Group By, Express, or Where in the Total row for this colum" error message." That is, during the first attempt session the query was not able to run. Any advice?

Please advise.

Thanks.

psimpson
 

Users who are viewing this thread

Top Bottom