Queries without data

A

Amateur

I have two queries:
1st Query is building the sum of payments
2nd Query calculated, based on the sum from query 1 the pending amount
If the is no data in query 1 the second query is not calculating the pending
amount.
Is it possible that, even if Query 1 has no data that at least one line is
showing with the value 0,00 because then query 2 will calculate correct.
Thanks
Klaus
 
M

Maurice

Hmm, is like asking: I know you don't have anything to show for but please
pretend you have nothing to show for by showing me 0.

If a query doesn't return a resultset it is supposed to return no resultset.
In that case you are trying to fix something that isn't broken.

Maurice
 
Top