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

Your question is not very clear but it sounds like you might need a crosstab query.

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.

psimpsonis 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?

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