Rows & Columns in Query

  • Thread starter Thread starter K11ngy
  • Start date Start date
K

K11ngy

I have the folowing task to do but do not really understand how to do this?
as below


Open the qryStudioMovies query and show the StudioName in rows and the
MovieTitle in columns. Save and close the query

Probably very easy but cant seem to work this out?

regards

Steve
 
Sounds like what you want is a crosstab query. When you do new query crosstab
is one of the options you can select. Read the access help file on crosstab
queries to see exactly how to lay it out.
 
Back
Top