Query paramete error

M

Mark

Hello All,

For some reason when I use a [Enter data] parameter in a queries criteria it
will not retreive any data, but if I add "000887479500" in it will work.
This is the case no mater if it is a text, or numeric field. I does it on
any feild I try.

I am using access97. I went to MS, but found no updates for it. Is there a
know bug, or is only me and my machine? Are there any settings that would
control this?

Thanks for looking.
 
J

John Vinson

Hello All,

For some reason when I use a [Enter data] parameter in a queries criteria it
will not retreive any data, but if I add "000887479500" in it will work.
This is the case no mater if it is a text, or numeric field. I does it on
any feild I try.

I am using access97. I went to MS, but found no updates for it. Is there a
know bug, or is only me and my machine? Are there any settings that would
control this?

Thanks for looking.
Click to expand...

Please post the SQL view of your query. I am not aware of any such
"bug", and I used many, many parameter queries in A97. I suspect there
is some other error in your query.

Indicate the datatype of the field being searched.


John W. Vinson[MVP]
 
M

Mark

John

Here is the SQL view of my query. The Field is text and my criteria is
numeric with leading zero's, but I have changed the parameter on the query to
text. I have also ran this on a text field with text criteria and nothing. I
will show this query in SQL view too at the end.

Thanks

This query works,

SELECT VIAWARE_WCS_TO_VIA_T.CONT, VIAWARE_WCS_TO_VIA_T.NEST_TO_CONT
FROM VIAWARE_WCS_TO_VIA_T
WHERE (((VIAWARE_WCS_TO_VIA_T.CONT)="000654035500"));

this one doesn't

SELECT VIAWARE_WCS_TO_VIA_T.CONT, VIAWARE_WCS_TO_VIA_T.NEST_TO_CONT
FROM VIAWARE_WCS_TO_VIA_T
WHERE (((VIAWARE_WCS_TO_VIA_T.CONT)="[Enter Container Number?]"));

This one doesn't either and the field is text and the criteria is text.

SELECT VIAWARE_WCS_TO_VIA_T.CONT, VIAWARE_WCS_TO_VIA_T.NEST_TO_CONT,
VIAWARE_WCS_TO_VIA_T.OP_CODE
FROM VIAWARE_WCS_TO_VIA_T
WHERE (((VIAWARE_WCS_TO_VIA_T.OP_CODE)=[data]));

I was trying to rule out if this is a text, numeric issue and with the last
query this has ruled it out with me.

John Vinson said:
Hello All,

For some reason when I use a [Enter data] parameter in a queries criteria it
will not retreive any data, but if I add "000887479500" in it will work.
This is the case no mater if it is a text, or numeric field. I does it on
any feild I try.

I am using access97. I went to MS, but found no updates for it. Is there a
know bug, or is only me and my machine? Are there any settings that would
control this?

Thanks for looking.
Click to expand...

Please post the SQL view of your query. I am not aware of any such
"bug", and I used many, many parameter queries in A97. I suspect there
is some other error in your query.

Indicate the datatype of the field being searched.


John W. Vinson[MVP]
Click to expand...
 
J

John Vinson

this one doesn't

SELECT VIAWARE_WCS_TO_VIA_T.CONT, VIAWARE_WCS_TO_VIA_T.NEST_TO_CONT
FROM VIAWARE_WCS_TO_VIA_T
WHERE (((VIAWARE_WCS_TO_VIA_T.CONT)="[Enter Container Number?]"));
Click to expand...

The reason it doesn't work is that it is searching for records where
the CONT field contains the literal text string [Enter Container
Number?] - and there probably won't be any.

Just remove the quotes.

John W. Vinson[MVP]
 
Top