If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Difference between fields in query
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, |
#2
|
|||
|
|||
Difference between fields in query
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] |
Thread Tools | |
Display Modes | |
|
|