Report - list details horizontally

[kimmarie021170]

Is there anyway in MS Access to list detail horizontally instead of vertically? I have searched everywhere I can think of, but can not find it.

for example my report reads:
Territory
DE
MD
VA
DC

I want it to read
Territory
DE MD VA DC

 

[Andrew Fergus]

Hi KimMarie and welcome.

Have you tried using a crosstab query? I think this will give you that you are looking for - you can use a crosstab query to give you the layout you want taht you can then use for your report.

Create a new query, add the tables and fields you want, Click Query -> Crosstab Query, in the crosstab row, set a number of fields to row headings (these items will appear vertically on the LHS of the query), choose one column heading (i.e. state?) which will appear horizontally across the top of the query, and choose one item to be the value. Change the "total : group by" for the "value" variable to be whatever it is you want (in the absence of additional information, the most commonly used one is "sum").

Save the query and base your report on this query.

Sorry for not being 100% specific (it can be a little tricky without all of the information) but if this doesn't work, just reply to this post and we can try again.

HTH, Andrew.