Re: No success with setting query criteria for returning empty

Tech-Archive recommends: Fix windows errors by optimizing your registry

It sounds like active Students have Null value for this Status Field. Try:

Is Null

in the criteria row for this Field column.

--
HTH
Van T. Dinh
MVP (Access)



"RC" <RC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05EBA8C3-D362-4C53-BC62-07E64A81FDD2@xxxxxxxxxxxxxxxx
>I have imported tables from another database into Access and one of these
> tables has a field that stores a value that denotes the status for each
> student enrolled in a school. The values appear as "N" for students "Not
> Returning" for a new school term, "I" for students withdrawing during the
> term and are "Inactive" for the remainder of the term, and what appears to
> be
> as "blanks" or "empty" for "active" students. Using a query on that table.
> I'm trying to set the criteria for the Status field so that it will return
> only "active" students, but having no success with trying conditions such
> as
> Not Like "N" And Not Like "I", or <> "I" And <> "N", or Like " ", or = "
> ".
> Each of these appear to return no data at all.
> The query runs fine when setting the criteria of the Status field as
> either
> Like "N" to return only the students "Not Returning", Like "I" to return
> only students withdrawing during the term, or Like "I" or Like "N" to
> return
> all the student who are not active. It's only when setting the criteria so
> that only "active" students are returned by the query that does not seem
> to
> work.
> I'm wondering if the Status field of the imported table could have some
> hidden value for the "active" students, and Access can "see" this value.
> The
> Status field appears as being "blank" or empty for "active" students in
> its
> original database as well. All help will be greatly appreciated.
> Thanks in advance,
> RC


.

Relevant Pages

  • Re: implimenting select...Case
    ... > 1) Have a combo/option group/whatever control that allows the user to pick ... > 3) The query that you use is then decided by a straight select case ... 'find all the students in a building ... >>> Its going to get worse cos ive been told that further criteria will be ...
    (microsoft.public.access.formscoding)
  • Re: monthly query
    ... I have a group of students who can take a selection of 18 different modules. ... So the criteria changes each month. ... I can run the query & revise it each month, but i have to do it all ... You can use Access' builtin date/time functions to create a dynamic criterion. ...
    (microsoft.public.access.forms)
  • RE: Query with Criteria Not Working
    ... "Robert T" wrote: ... The problem occurs whenever I add a criteria, that's when the query fails to ... I'm trying to build a query that counts the number of students who ...
    (microsoft.public.access.queries)
  • RE: Query with Criteria Not Working
    ... I placed the criteria under the count because in that particular case, ... want to count the number of students who actually attended the class. ... I tried your SQL but I received the same error message. ... The problem occurs whenever I add a criteria, that's when the query fails to ...
    (microsoft.public.access.queries)
  • RE: Compare Column to Inbput Box Variable
    ... The first criteria is to select all of the test ... students I need from my current work sheet? ... If ActiveCell.Value = TestClass Then ...
    (microsoft.public.excel.programming)