Search results

Thanks Bob, That did the trick. Im embarrased about how long this has hung me up, but I'm still learning.

Thanks for the suggestions so far, but I still need a little help. I can create a single query that will pull in all fields of interest, but it returns duplicate parent records for each child record. I don't know if that is the correct terminology, so I'll go back to my states and cities...

I am trying to run a subreport for every record in a main report. How can I pass a parameter from the main report query to the subreport query. The way I have it set up now, the subreport prints the desired fields for ALL records in the main report for each record in the main report. I don't...

I am trying to create a report based on several fields from a single query. When I run the query, everything is as it should be. However, when I run a report from that query, each query record appears 2x in the report. I'm thinking maybe the query needs to be cleared before re-running? Any...