Perameter Query... I'm completely annoyed

[Guest]

Okay, so i have been learning very slowly the dos and dont's of access. But
when I try to make a query (perameter or simple) it is not coming up with the
info that I need.

I have a column in my table that I list which community a person lives in.
Currently I have only two different communities (we'll call them community
"A" and "B"). When I set up the perameter I did [what community would you
like to view] in the "community" column of the query while in design view.

I clicked on the "run" button, typed in "A" and wouldn't you know... it
worked! BUT when I tried it again and put in "B", the query came up blank...


I tried the same thing with a simple query by replacing "A" & "B" in the
criteria row... "A" showed up, "B" didn't...

please help!

 

[Rick Brandt]

Okay, so i have been learning very slowly the dos and dont's of
access. But when I try to make a query (perameter or simple) it is
not coming up with the info that I need.

I have a column in my table that I list which community a person
lives in. Currently I have only two different communities (we'll call
them community "A" and "B"). When I set up the perameter I did [what
community would you like to view] in the "community" column of the
query while in design view.

I clicked on the "run" button, typed in "A" and wouldn't you know...
it worked! BUT when I tried it again and put in "B", the query came
up blank...


I tried the same thing with a simple query by replacing "A" & "B" in
the criteria row... "A" showed up, "B" didn't...

please help!

Then clearly the records you think contain "B" do not. Is it possible they have
a leading space?

 

[Guest]

I just checked to see if there is a leading space for those records that have
"B" and there is no leading space. I do know that the records have the value
that I am looking for because the table that the query is made from shows
the value in the column.


--
Justin

Okay, so i have been learning very slowly the dos and dont's of
access. But when I try to make a query (perameter or simple) it is
not coming up with the info that I need.

I have a column in my table that I list which community a person
lives in. Currently I have only two different communities (we'll call
them community "A" and "B"). When I set up the perameter I did [what
community would you like to view] in the "community" column of the
query while in design view.

I clicked on the "run" button, typed in "A" and wouldn't you know...
it worked! BUT when I tried it again and put in "B", the query came
up blank...


I tried the same thing with a simple query by replacing "A" & "B" in
the criteria row... "A" showed up, "B" didn't...

please help!

Then clearly the records you think contain "B" do not. Is it possible they have
a leading space?

 

[Rick Brandt]

I just checked to see if there is a leading space for those records
that have "B" and there is no leading space. I do know that the
records have the value that I am looking for because the table that
the query is made from shows the value in the column.

And that table column is not using a lookup field and has no formatting that
might make what you *see* different than what is stored?

 

[John Spencer]

As a test, try criteria of <> "A" and see what is returned.

 

[Guest]

I have attempted this <> "A" and still nothing comes up.

Also there is no lookup function in this table (i don't know how to do
those), and the formatting is correct.

 

[Guest]

Okay, so I just tested something else. My query that I was having issues
with had a few columns from another table. When I removed this table from
the query, the perameter query functions correctly. I don't know why this
would keep it from working correctly.

 

[John Spencer]

Perhaps because the other table was restricting the results that were
returned to only records that had "A". For instance, if there is only a
record in the other table if the value in the field you are querying is "A"
then that would cause a problem unless you changed the join from an INNER
join to a LEFT or RIGHT join.