queries/expression builder on a report 1

[soontobefour]

In my report I list incidents based in status, which comes from an incident table. I also have a notes table that stores additional notes related to a particular incident. I need to create a query that will pull the right notes related to the incident.

ie:
Status IncidentId Severity Decription Open Date Notes

Notes.controlsource = (SELECT [Note] FROM [AdditionalComments] WHERE [AdditionalComments!IncidentID] = [Me!IncidentID])

this yields: #Name? om the report.

Please tell me how to get the data.

 

[cghoga]

You need to create a query.
Include the tables (Incident, Notes) you will be pulling data from.
Join the tables based on IncidentID (I am assuming both tables have the IncidentID field).
Make sure you select the fields (by doubleclicking or dragging) from your tables you want to display in your report.
Save the query.
In the RecordSource property of your report choose your query.
Try running the report.
This should allow you to see notes for corresponding Incidentid.

Hope this helps.

 

[soontobefour]

Cghoga,

your advise was the trick. That was alot quicker to implement than the hours of playing with the expression builder and searching the web for information on how to do this.


two thumbs up!!!