Difference between fields in query

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

 

[Marshall Barton]

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.

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

Difference: Count (table1) - Count (table2)