The following will open the form no matter the status of the lname column
*EDIT USING form1 *
The WHERE clause is optional, even if you specify an ORDER BY
*EDIT USING form1 ORDER BY lname *
is legal, and the NULL rows will appear last in the selection
Gary Randall wrote:
Hello All,
I am running into a issue that I haven't had before and I am out of
ideals, I am hoping someone could help me see what I am sure is right
in front of me.
Here is a where clause I am using:
EDIT USING form1 WHERE lname LIKE '%'
If there is a row where the lname column is empty this where clause
will skip it. I have tried CONTAIN and it behaves the same. Is there
a way to make the where clause return all the rows even the ones that
have no data in the lname column?
Thanks
Gary Randall
