Hi, the problem I am having is that I have 3 fields ActivityID, FeatureID and Value in a table. The activityID is a foreign key for another table and therefore can be used more than once my problem is that the value I need for a report only is given when FeatureID equals 7. I have made a query that shows just the field but I know need to attach that field in the query to my report. How do I accomplish this?