G
Guest
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
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