Linking DISTINCT & NON DISTINCT Queries (1 Viewer)

vdanelia

Registered User.
Local time
Today, 07:11
Joined
Jan 29, 2011
Messages
215
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

AWF VIP
Local time
Today, 15:11
Joined
Jan 22, 2010
Messages
26,374
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

AWF VIP
Local time
Today, 15:11
Joined
Jan 22, 2010
Messages
26,374
Tell us exactly what you want to do in your report.
 

vdanelia

Registered User.
Local time
Today, 07:11
Joined
Jan 29, 2011
Messages
215
I'll try to make Sub-report and then merge, but how to count the totals with merged report?
 

vbaInet

AWF VIP
Local time
Today, 15:11
Joined
Jan 22, 2010
Messages
26,374
* Count it in the subreport and reference the textbox in your main report

OR

* Use DCount()
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom