Solved

MS ACCESS

Posted on 2013-01-15
15
126 Views
Last Modified: 2013-03-08
Im trying to run a query.. what do I need to type if I want to prioritized a field that is with check mark Format @.. in other words what do I need to type in criteria.....

Thanks for any help
0
Comment
Question by:gabgar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
15 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38779648
what do you mean by prioritized ?
sorted ascending or descending ?  there is a sort row which you can select Ascending or Descending or not sorted
0
 

Author Comment

by:gabgar
ID: 38779888
That only shows the ones marked.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38779917
use the criteria row, what kind of information are in the field ? check marks ? is this a YesNo field?


fieldName   [nameofField]


criteria      -1

to show all the Yes values

criteria  0

to show all the NO values

if this is a Text Data type field

criteria Is Null

to show all null "empty" record


Criteria Is Not Null

to show all records with values
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38779985
Can you upload a copy of your db..

give details of what exactly you want to do..
0
 

Author Comment

by:gabgar
ID: 38780346
is like what (show: mark or not mark has).
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38780364
criteria  Like "mark"

will show all with marks


criteria Not Like "mark"

will show all without mark
0
 

Author Comment

by:gabgar
ID: 38780388
wont show anything.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38780562
upload a copy of your db


.
0
 

Author Comment

by:gabgar
ID: 38782606
Thanks It was -1, was pulling the wrong field to the query.
0
 

Author Comment

by:gabgar
ID: 38782730
I will be working a lot now with access like never before hope You guys can help me with this new transition.

Thanks a lot.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38782740
ok.. just don't forget to close this thread
0
 

Author Comment

by:gabgar
ID: 38782881
you mean if I have another question just post a new one right?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38782907
that is correct, just try to limit the thread to the single question you first posted.
0
 

Author Comment

by:gabgar
ID: 38840661
thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 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