[RESOLVED] generate access report by survey id

Hi All,

I am confident in creating access reports but:
How do I generate an access report by ID?

OK, this is the scenario:

The survey officer enters the survey Id (there can be thousends survey id and associated scores) into a txtBox and clicks a CommandButton.

1. the system checks if survey id exists
2. the system checks if basic scores are loaded for survey id
3. the system calculates the scores
4. displays the report for that particular syrvey id

How do I go about point 4?

Thanks in advance.

Svetlana

How would you go about creating any other kind of access report?

I image you would base the report off of an SQL query, and this one would be no different.

The way I was doing it before was create a query in access and display query results in access report.
What I need now to do is create a access report by passing a parameter or value from vb 6 frontend.

Thanks.