Query paramete error

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.

On Tue, 24 May 2005 19:14:01 -0700, "Mark"
wrote:

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.

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]

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" wrote:

On Tue, 24 May 2005 19:14:01 -0700, "Mark"
wrote:

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.

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]

On Tue, 24 May 2005 23:20:01 -0700, "Mark"
wrote:

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?]"));

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]