Query help

[COMPSCI610]

How do you get this to terminate on a null value or empty value.

SELECT STORPOGTRASH.[SPOG#], STORPOGTRASH.[POGSTR#]
FROM STORPOGTRASH
WHERE (((STORPOGTRASH.[SPOG#])=[PLEASE ENTER A PLANOGRAM NUMBER]));

Any help would be greatly appreciated

 

[Clifford Bass]

Hi,

Instead of the build in parameter feature, use your own parameter form
with a text box for entering the information. On that form you can have a
button. When the user clicks the button check check if the text box is null
or a zero-length string. If it is, complain to the user, otherwise open up
the query or report or whatever. Change the query to some thing like the
following so it uses the text box from the form.

SELECT STORPOGTRASH.[SPOG#], STORPOGTRASH.[POGSTR#]
FROM STORPOGTRASH
WHERE
(((STORPOGTRASH.[SPOG#])=Forms![frmMyParameterForm]![txtParameterField]));

Clifford Bass