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

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).]

Top one, solved the problem, what a star!

Many thanks

Rob McCreedie