Solved

Access 2007 Query Multi Fields

Posted on 2014-09-18
7
195 Views
Last Modified: 2014-09-23
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
Comment
Question by:CMILLER
  • 5
  • 2
7 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40331839
see query1
Database5.mdb
0
 

Author Comment

by:CMILLER
ID: 40332661
Rey, it looks good except for the first employee num 12345, it shouldnt be showing up in the query
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40332691
why?
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:CMILLER
ID: 40332711
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
 

Author Comment

by:CMILLER
ID: 40332768
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
 

Author Comment

by:CMILLER
ID: 40332777
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
 

Author Comment

by:CMILLER
ID: 40339457
I will close this question.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question