M
Melissa
I have a parameter query which prompts the user to "Enter
Class" - which is a 4 digit field reflecting the
graduation year of high school students.
The code I have written into the criteria field of the
query is:
Like [Enter Class] & "*"
I want this same query to work for the following:
1. Pull a select class, such as 2005. This works.
2. Pull all records that have any class entered. This
works.
3.Pull only the records that have no class entered, i.e.
is null. I had thought that just pressing enter when
prompted for "Enter Class" would work; but it doesn't.
4.Pull all records whether Class is null or not. This
doesn't work either.
Thanks in advance for your help.
Class" - which is a 4 digit field reflecting the
graduation year of high school students.
The code I have written into the criteria field of the
query is:
Like [Enter Class] & "*"
I want this same query to work for the following:
1. Pull a select class, such as 2005. This works.
2. Pull all records that have any class entered. This
works.
3.Pull only the records that have no class entered, i.e.
is null. I had thought that just pressing enter when
prompted for "Enter Class" would work; but it doesn't.
4.Pull all records whether Class is null or not. This
doesn't work either.
Thanks in advance for your help.