Queries without data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries calculation 1
Parameter Value error in a Subform 0
Access Query problem 1
incorrect IIF condition 4
Odd query behavior 3
"Enter Parameter Value" 4
Query question - limit amounts included in sum by date 5
Query fields 2

Back
Top