Solved

MS ACCESS

Posted on 2013-01-15
15
121 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
  • 7
  • 7
15 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
Comment Utility
That only shows the ones marked.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
Can you upload a copy of your db..

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

Author Comment

by:gabgar
Comment Utility
is like what (show: mark or not mark has).
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
criteria  Like "mark"

will show all with marks


criteria Not Like "mark"

will show all without mark
0
 

Author Comment

by:gabgar
Comment Utility
wont show anything.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
upload a copy of your db


.
0
 

Author Comment

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

Author Comment

by:gabgar
Comment Utility
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 119

Expert Comment

by:Rey Obrero
Comment Utility
ok.. just don't forget to close this thread
0
 

Author Comment

by:gabgar
Comment Utility
you mean if I have another question just post a new one right?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
that is correct, just try to limit the thread to the single question you first posted.
0
 

Author Comment

by:gabgar
Comment Utility
thanks
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now