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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
I need to sum up some values in a column of a query 2
Summary row in crosstab query? 3
query return only one row with averages 4
Can a Add a String to a Union Query? 4
How to display multiple IIf results in one column 1
Make-table query with around 2 ml records taking too long 0
Crosstab Query Column headings 4

Back
Top