Transferring Qry to report

[Philbot]

I have a query that returns 10 questions with the answers previously given by the users e.g.

Question ID Answer
1 Yes
2 No
3 N/A etc..

On my report I need to collect this information not as a list but is individual boxes scattered around the page so I cannot just retrun the list as a general list via the query (bit hard to explain).

Can anybody please tell me how I can transfer this data to the relevant parts of my report could I use a dlookup in each of the fields?

DLookUp("[Answer]","QryQuestions" where Question Id =1) im guessing here?


many thanks

 

[ColinEssex]

I'm having a problem with what you mean

Are you wanting only the questions with IDNo1 (or 2 or 3)?

Col

 

[Philbot]

ummm ok my report will look like this:-



Question 1 = ?? some other text goes here



and maybe questions 2 is over the right hand side of my report say here-------------------------------------------> Question 2 = ??

So my report returns data from a qry showing 20 question and answers given for this particular record but I do not know how to get them to show on my report page?

thanks

 

[Philbot]

Ok I will try a different approach I am trying to lookup the question number so to return the answer from a query. On my form for the answer to question 1 I have tried this in a bound field

DLookup("[Drawing Enclosed]", " QryCDMAnswerReport ", "[ProjectNumber]="[Forms]![Main Form]![PN]) & “[QuestionID]=1”)

So the Report sends the projectnumber to the query and ask for the answer to Question ID no. 1

The above look up is giving me a syntax error?

the query is as follows:-

SELECT TblCDMRiskAssesment.[Project Number], TblCDMRiskAssesment.QuestionID, TblMatrixCDMRiskAsmt.Question, TblCDMRiskAssesment.Comments, TblCDMRiskAssesment.[Drawing Enclosed]
FROM TblMatrixCDMRiskAsmt INNER JOIN TblCDMRiskAssesment ON TblMatrixCDMRiskAsmt.QuestionID = TblCDMRiskAssesment.QuestionID
WHERE (((TblCDMRiskAssesment.[Project Number])=[Forms]![Main Form]![PN]))
ORDER BY TblCDMRiskAssesment.QuestionID;

 

[Philbot]

Well thanks very much Pat, yes a simple cross tab query was all that was needed !!!

Great stuff!!!