Linking DISTINCT & NON DISTINCT Queries (1 Viewer)

[vdanelia]

Hello Dear friends,
I have a question if it is possible and is the right way to join 2 Queries, 1 Distinct and the Second non Distinct
Both of them is working properly independently

 

[vbaInet]

I'm pretty sure I've answered this question in another thread before. You can join them fine but you cannot have a mixture of DISTINCT and non distinct. It's one or the other.

 

[vbaInet]

Tell us exactly what you want to do in your report.

 

[vdanelia]

I'll try to make Sub-report and then merge, but how to count the totals with merged report?

 

[vbaInet]

* Count it in the subreport and reference the textbox in your main report

OR

* Use DCount()

 

[vdanelia]

I'll Try Everything!