Chris Miller
asked on
Access 2007 Query Multi Fields
In my attached DB I have a flag table and what I am needing to do is to be able to only show data in the query when the flag is "0" zero.
I have attached a result file of what I want the query to show.
Database5.mdb
Result.xlsx
I have attached a result file of what I want the query to show.
Database5.mdb
Result.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
why?
ASKER
there isnt a "0" in the either flag field. I only need the flags that are set to "0"
If you look at my results.xlsx file, these are the only ones that flaged to "0"
23456
34567
45678
I will post a little more information about the query
If you look at my results.xlsx file, these are the only ones that flaged to "0"
23456
34567
45678
I will post a little more information about the query
ASKER
I made a table from a excel flag report that I receive every two weeks and have been trying to figure out how to set this up so its easy to export reports.
There are 27 different flags that are divided into two different branches and two different departments in each branch.
There are 27 different flags that are divided into two different branches and two different departments in each branch.
ASKER
Do you think the best way would be to create just a flag table with the 27 different flags, then create branch and department tables and then query from those?
ASKER
I will close this question.
ASKER