Hi,
I have a question on how to prioritize criteria in Access. For example, I have this excel doc that I always import to access. Let's call this document A.
Document A has 2 fields:
Employee ID
$ Amount
1 Employee ID can have multiple rows of $ Amount...
The values in "$ Amount" field can be positive or negative..
I currently have this query that groups it based on Employee ID and sum the $ Amount...
So, if Employee ID 1000 has 1000, -500, 700, -200. Then my access query will show this result:
Employee ID $ Amount
1000 1000
I would also like to build another criteria on top of that: If the SUM of the $ Amount if <1000 or >-1000, then I want to exclude that employee ID...
So in summary, here are the criterias:
1. Sum the values in the "$ Amount" field
2. Exclude those employees with negative SUM
Sum the values first and exclude the ones with negative SUM...
How to tell access to go through the first criteria first before proceeding to the 2nd criteria? I've attached an example of the excel file here.
Thanks!
Bookmarks