How do I prevent the last record in the Access table, you know, the one which is still empty, prevent from showing up in queries. Is there a general rule?

Alie :)

Hi Alie,
Include checking the value of a mandotary(Primary key) field not NULL in WHERE clause.

There is no way to disallow showing last (empty) record when is the query updateable.

Peko

Hi nalla ,

 Iam having this doubt soo long but iam n't able to understand the method u said. wat's ur point of explenation. ur demons in SQL language..! pls give me an clarification so that i can also understand

thank's Bye
pap Raguv

Nalla means this (in my opinion):

You create Query and type in SQL View something like this:
SELECT <field_name(s)> FROM <tablename> WHERE <primary_field_name> Is Not NULL

But this have not effect about visibility of last (empty) record.

If I mistake and Nalla means something other, please, excuse me.

Peko