Difference between fields in query

  • Thread starter Thread starter NPell
  • Start date Start date
N

NPell

Hello,

i have a query in which i am trying to show a total number of items,
then a total number of items with a criteria from a different table.
Then calculate the difference:

The way the query is set up is:
Date (table1)
Date: Count (table1)
Date: Count (table2)
Difference between CountofDate(tbl1) and CountofDate(tbl2).

The first bit all works fine, its the difference i am struggling with.
There is prompt for a parameter value for CountofDate(tbl1) and then
CountofDate(tbl2).
I click ok without entering for both and the result is totally fine,
its just this unneccessary (and confusing) parameter prompt.

Any ideas?
Regards,
 
NPell said:
Hello,

i have a query in which i am trying to show a total number of items,
then a total number of items with a criteria from a different table.
Then calculate the difference:

The way the query is set up is:
Date (table1)
Date: Count (table1)
Date: Count (table2)
Difference between CountofDate(tbl1) and CountofDate(tbl2).

The first bit all works fine, its the difference i am struggling with.
There is prompt for a parameter value for CountofDate(tbl1) and then
CountofDate(tbl2).
I click ok without entering for both and the result is totally fine,
its just this unneccessary (and confusing) parameter prompt.
Click to expand...


Instead of using the alias names for the calculated fields,
use the expressions:

Difference: Count (table1) - Count (table2)
 
Back
Top