Not function

[mcreedie]

I hope this will be an easy question for the high calibre members of this forum.

I have tried to add the Not criteria to elimate all records taht have Nursing Midwifery in a certain. It takes out the fields containing the specified data but it also removes any blank fields, does any one have any ideas.

Many thanks in anticipation,

Rob McCreedie

 

[Rich@ITTC]

Hi Rob

In your first row for the query criteria you presumably have something like:

Not "Nursing Midwifery"

At the moment, and quite correctly, Access is eliminating any records that have a blank (or Null) value in the relevant. You need to add the following in the criteria row below (in the same field) - in the row beginning Or:

Is Null

This means Access will return all records that have a value different from "Nursing Midwifery" AND all those records with a Null value (empty/blank fields).

HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 09-03-2001).]

 

[mcreedie]

Top one, solved the problem, what a star!

Many thanks

Rob McCreedie