Hey guys! need help.. I'm working on a report that uses 2 queries (qry_A, qry_B) and 1 table (tbl_1) that are unrelated. First part of the design only uses qry_A and when i get to the part where i have to use qry_B the data shows 0, but whenever I Browse the data for that formula it shows the data I want to show up.  take note .. i didn't  use any group selection or any type of selection of this report.. It's just a blank report where i could put in all types of data using a formular..  Thank you in advance...

 No. if you mean duplicate record of data on any of the query or table.

I forgot to mention it the first time.... I would like to avoid using subreports if possible.

Thanks so much for the insight.... One more thing... on groupings.. is there a way to place a data inside the report  and ignore the grouping selection/parameter?.. is so how.. if not... how to work around it without using subreport.. thanks again.