why does query ask for input criteria twice

V

Vanessa

I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?
 
J

Jeff Boyce

Vanessa

The most common reason this happens is because there's a spelling mistake
somewhere, and Access is actually asking two separate questions/prompts.

What happens if you re-create the query from scratch and use the criterion
you described?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Gary Walter

Vanessa said:
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?

In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.
 
J

Jeff Boyce

Gary

?!"sage" -- doesn't that imply grey and grizzled?

<G>Jeff

Gary Walter said:
Vanessa said:
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?

In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.
 
D

Duane Hookom

Yep...

--
Duane Hookom
MS Access MVP

Jeff Boyce said:
Gary

?!"sage" -- doesn't that imply grey and grizzled?

<G>Jeff

Gary Walter said:
Vanessa said:
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?

In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.
 
G

Gary Walter

I defer to Duane. :cool:

Actually, if that's what it means,
I'm probably "sager" than either of you...
(had first grey hair in junior high school)

I had to leave Colorado for fear of
being taken for a grizzly and shot.

Well, that last part is not true....
I look more like a silverback gorilla
than a grizzly...

Jeff Boyce said:
Gary

?!"sage" -- doesn't that imply grey and grizzled?

<G>Jeff

Gary Walter said:
Vanessa said:
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?

In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.
 
G

Gary Walter

It seems like just yesterday those long
difficult sessions as Diane Fossey taught
me how to sign...

then the big, beaming smile on her
face when I signed asking if she could
teach me MS Access...
I defer to Duane. :cool:

Actually, if that's what it means,
I'm probably "sager" than either of you...
(had first grey hair in junior high school)

I had to leave Colorado for fear of
being taken for a grizzly and shot.

Well, that last part is not true....
I look more like a silverback gorilla
than a grizzly...

Jeff Boyce said:
Gary

?!"sage" -- doesn't that imply grey and grizzled?

<G>Jeff

Gary Walter said:
:
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after
the
information has been entered - how can I stop this?

In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top