Hi Mes73,
you had mentioned that, "I need a report that has table 1 row 1 and all info. from table 2 that is +/- 300 then same for table 3 that is +/- 300".
As you want to records from 3 Tables here I would recommend you to use Union Query.
with the help of that you can combine 3 queries in single query.
then to get only first row from the first table you can use "Top 1".
to get only "+/- 300 " data from other two tables you can use Where clause in your query.
Following are the links for "Union Query","Top" and "Where Clause". so please visit the link below to get information how to use it.
Combine the results of several select queries by using a union query
TopValues Property
Access SQL: WHERE clause
after you create your query successfully then assign this query to Record Source of the Report.
Use a query as the record source for a form or report
Regards
Deepak
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.