Unanswered: report to return information based on a field in the query
OK, this is probably a dumb question but…here goes
I want my report to return information based on a field in the query. For example: I have several records that contain the redundant data but instead of reiterating everything in the form for each record I would like it to see if the data in one of the fields is equal a value and return data for several other fields based on the first value. I hope that I am making sense. I don’t work much with databases (obviously) so thanks for the help and please try and keep it simple for the DB impaired.