Prev: Bug in Access - update with subquery
Next: Query to get information that doesn't match by date
From: NPell on 24 Feb 2010 10:49
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,
From: Marshall Barton on 24 Feb 2010 11:46
NPell wrote:

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

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Bug in Access - update with subquery
Next: Query to get information that doesn't match by date