MS ACCESS

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
gabgarAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
gabgarAuthor Commented:
That only shows the ones marked.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
Rey Obrero (Capricorn1)Commented:
Can you upload a copy of your db..

give details of what exactly you want to do..
0
 
gabgarAuthor Commented:
is like what (show: mark or not mark has).
0
 
Rey Obrero (Capricorn1)Commented:
criteria  Like "mark"

will show all with marks


criteria Not Like "mark"

will show all without mark
0
 
gabgarAuthor Commented:
wont show anything.
0
 
Rey Obrero (Capricorn1)Commented:
upload a copy of your db


.
0
 
gabgarAuthor Commented:
Thanks It was -1, was pulling the wrong field to the query.
0
 
gabgarAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
ok.. just don't forget to close this thread
0
 
gabgarAuthor Commented:
you mean if I have another question just post a new one right?
0
 
Rey Obrero (Capricorn1)Commented:
that is correct, just try to limit the thread to the single question you first posted.
0
 
gabgarAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.