Rows to columns - can it be done?

  • Thread starter Thread starter annysjunkmail
  • Start date Start date
A

annysjunkmail

Hi,
This would be a great help if it can be solved.
I have 4500 applications for funding.
Each application must meet max 6 conditions to receive funding.
Applications are stored in tblApplication and conditions are stored in
tblConditions.
I have created a query that shows Applications & conditions but my
problem is that I get multiple applications due to multiple conditions.


A workaround would be if the query could be set up in such a way that
it displays the 6 conditions as columns, display unique ApplicationNo's
and add a Yes under relevant column if conditon detected, or blank if
not detected.

Grateful for expert help please.
Tony
 
Tony,

You need to make a Crosstab query. Look it up in Access help.

HTH,
Nikos
 

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

Merging queries by column in access 1
Column limits on queries 1
Switch from Rows to Columns 13
query issues - critera being ignored 4
Storing VBA Code In a Cell to Use real Time 2
Append query without duplicate rows 3
Using Crosstab column headings for conditional formatting in report 0
Is it possible and how can it be done? 5

Back
Top