Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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
0
CMILLER
Asked:
CMILLER
  • 5
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
see query1
Database5.mdb
0
 
CMILLERAuthor Commented:
Rey, it looks good except for the first employee num 12345, it shouldnt be showing up in the query
0
 
Rey Obrero (Capricorn1)Commented:
why?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CMILLERAuthor Commented:
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
0
 
CMILLERAuthor Commented:
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.
0
 
CMILLERAuthor Commented:
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?
0
 
CMILLERAuthor Commented:
I will close this question.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now