Filtering records not equal to another field

  • Thread starter Thread starter PaulineC
  • Start date Start date
P

PaulineC

I am trying to open a form filtering data using a hidden
popup form.
This part works fine but the problem is as follows:
There are two fields on the form;
One is a CourseFileNo (this is selected from the pop-up
form) and the other is [LastCourseFileNo].
I am trying to further filter out records - using a query -
showing only the ones that the [LastCourseFileNo] doesn't
equal the [CourseFileNo].
In the criteria I have tried
Not Like Forms!fmSelectYears!FileNo
Andn also
<> Forms!fmSelectYears!FileNo
I have also tried putting an SQL statement in the criteria
of the StudentId as follows:
SELECT [StudentId] FROM[tbCourseParticipantDetails] WHERE
[LastCourseFileNo] <> [CourseFileNo]
Can anyone help me with this
 
Cancel this request as I have finally found the problem.
All I had to do was to add Null as there wasn't any data
in a lot of the records.
 
Back
Top