Re: Queries
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Carp wrote:
Hello,
I am trying to run a query to find every instance that a number lower than
255 appears in a field for each record. The query should run for several
fields for each record. I have tried typing <255 in criteria, but I am
having a problem. If one of the fields in the record ever has a number
greater than 255, then that record does not show up when I run the query.
What I am trying to do is run a query that will indicate anytime a number
smaller than 255 appears in any field on a record.
Try putting the <255 on different criteria rows. When they
are on the same criteria row, all of them must be true
(AND), on separate rows then any one or more of them can be
true (OR).
--
Marsh
MVP [MS Access]
.
Relevant Pages
- Re: Using Null in query criteria
... query that I need to return records that have an empty Date_Closed ... field when the value of fraComplaint is 2 and all records when the ... In the first 2 criteria rows enter ... show all recs. ...
(comp.databases.ms-access) - Re: Selected Criteria or All
... When you save the query, Access will restructure it and add a calculated ... If this is the only field that you are applying criteria against you will ... end up with two criteria rows. ... If you are applying criteria to multiple fields but they are all on the same ...
(microsoft.public.access.queries) - Re: Selected Criteria or All
... When you save the query, Access will restructure it and add a calculated ... If this is the only field that you are applying criteria against you will ... end up with two criteria rows. ... If you are applying criteria to multiple fields but they are all on the same ...
(microsoft.public.access.queries) - Re: help designing query to get results
... Use actually the same expression in the criteria rows under each of your 3 date fields: ... While in design view, click on Query on menu bar, then select Parameters from menu list. ... In the popup window, type the parameters exactly as you'll have them in the query, and select Date/Time as the datatype for each. ...
(microsoft.public.access.tablesdbdesign) - Re: Need One Query to Search Multiple Date Fields, If Possible
... Put your criteria in the design of the query like this... ... but on different criteria rows of the query ... design grid. ... > or nine-month evaluation. ...
(microsoft.public.access.queries) |
|
