• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

Access Report

Dear Experts

I need to produce a report to show responses for an event (ie Yes / No / Maybe)

The report is basically a list of names which are grouped by their response.  I would like to show the results in 3 columns - this I can do but only by applying columns to the whole report which means that each grouping starts on a new page - which I don't want.

Is there a way to in effect just apply columns to the detail section of the report?

Alternatively is there a clever way round this issue

Many thanks
0
correlate
Asked:
correlate
  • 5
  • 3
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
create a query with these columns , and use the query as the record source of your report

YesResp:IIF([response]="Yes","Yes","")  
NoResp:IIF([response]="No","No","")  
MaybeResp::IIF([response]="Maybe","Maybe","")  


see if that will work for your report
0
 
correlateAuthor Commented:
Hi capricorn1

Thanks for that - I tried it but has the same effect as per previously - the original query had 2 columns [Full Name] & [Attending].  or have I missed in what you're suggesting
0
 
Rey Obrero (Capricorn1)Commented:
post the sql statement of the query
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
correlateAuthor Commented:
Thanks Will post it in the next hour or so - am out at present but will post it when I'm back in
0
 
correlateAuthor Commented:
Hi capricorn1

here is the query ,..

the original ( I added a grouping bit to put the groupings in order) ....

SELECT [AGM This Year Responses].[Full Name], [AGM This Year Responses].Attending, IIf([Attending]="Yes",1,IIf([Attending]="No",2,IIf([Attending]="Maybe",3,4))) AS GroupOrder
FROM [AGM This Year Responses];

Open in new window


The one post your post ...

SELECT [AGM This Year Responses].[Full Name], [AGM This Year Responses].Attending, IIf([Attending]="Yes","Yes","") AS YesResp, IIf([Attending]="No","No","") AS NoResp, IIf([Attending]="Maybe","Maybe","") AS MaybeResp
FROM [AGM This Year Responses];

Open in new window


many thanks
0
 
Rey Obrero (Capricorn1)Commented:
did you use the last sql statement as the record source of your report?

open report in design view,
add three textboxes and set the control source to YesResp, NoResp, mayBeResp  accordingly

you can remove the textbox for "Attending" if you want to.
0
 
correlateAuthor Commented:
Ok cool, will give it a go in the morning
Many thanks
0
 
correlateAuthor Commented:
Thanks v much for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now