Filtering certain records

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I have a membership database, but not all people in the main table are
members. I have a column named "nonmember" and in this column I use
different words/phrases to help me know why they are in the database but not
a member.

I need my form to pull from the main table but only pull members. I was
thinking I could use the filter in the form design view but I can't seem to
come up with the right expression for it to work. I want it to pull all
records where the nonmember field is null.

Any help on this would be greatly appreciated.

Thank you in advance!
Rebecca S.
 
You need to have your form pull the records using a query so you can tell it
which records you want. Assuming you already have a form that pulls all of
the records....

1. Make a copy of that Form.
2. In the Form Properties - Record Source, click on the ... (three dots) and
go into Query builder.
3. Build you Query and in the Criteria for "Nonmember" put "Is Null"
4. Save everything and open the form and you should only see the Member
(Null Nonmember) Records.

Now Make a copy of that new Form and go into the Form Properties - Record
Source, open the Query and change the Query to "Is Not Null" and save
everything.

Now open that form and you should only see the Nonmember Records.
 
Thank you I will try it!

Rebecca S.

admin said:
You need to have your form pull the records using a query so you can tell it
which records you want. Assuming you already have a form that pulls all of
the records....

1. Make a copy of that Form.
2. In the Form Properties - Record Source, click on the ... (three dots) and
go into Query builder.
3. Build you Query and in the Criteria for "Nonmember" put "Is Null"
4. Save everything and open the form and you should only see the Member
(Null Nonmember) Records.

Now Make a copy of that new Form and go into the Form Properties - Record
Source, open the Query and change the Query to "Is Not Null" and save
everything.

Now open that form and you should only see the Nonmember Records.
Click to expand...
 
Rebecca,

I would have probably made your nonmember field be a member
field with a Yes/No flag and then maybe had another text
field for the NonMember reason. This way you just filter for
Member = Yes. With the way you have it setup, I would now
build yourself a qryMembers query that uses the criteria of
'Is Null' in the NonMember field and then base your form on
the query instead of the table.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top