Query not returning results for a text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running what I thought was a very simple query to return records based
on a field called ProviderID. The data type is text due to the possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a provider I
know is in the table, I get no records.
I have queried every other field in the table (all fields text) and get
results.

I'm sure I'm missing something very basic, but I'm at a complete loss! Any
help would be greatly appreciated, and let me know if I need to post more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
 
Jay

Any chance that field in the table is defined as a "lookup" data type?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019". When
I put this in the criteria field it returns no results. Here is the SQL if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));
 
Jay

Have you tried using copy/paste to take a value that exists in the table and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named [GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019".
When
I put this in the criteria field it returns no results. Here is the SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


Jeff Boyce said:
Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria field,
but no results. I use similar tables every day and have never had this come
up.
Thanks again for your help

Jeff Boyce said:
Jay

Have you tried using copy/paste to take a value that exists in the table and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named [GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019".
When
I put this in the criteria field it returns no results. Here is the SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


Jeff Boyce said:
Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text) and get
results.

I'm sure I'm missing something very basic, but I'm at a complete loss!
Any
help would be greatly appreciated, and let me know if I need to post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
OK, once I've tried various combinations, up to and include copy/paste and
still have a query that fails, I throw the query away and create a new one.

Is this problem showing up with ALL your queries, or only this one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria field,
but no results. I use similar tables every day and have never had this
come
up.
Thanks again for your help

Jeff Boyce said:
Jay

Have you tried using copy/paste to take a value that exists in the table
and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named [GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019".
When
I put this in the criteria field it returns no results. Here is the
SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED
DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


:

Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text) and
get
results.

I'm sure I'm missing something very basic, but I'm at a complete
loss!
Any
help would be greatly appreciated, and let me know if I need to post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
No, it's no problem to start over, but that's what I've been doing. Since
I'm just getting started with this project for my boss I have created new
query after new query. I have even exported the table and re-imported
knowing that this shouldn't matter, but running out of ideas.
I can use other fields to get the data I need, but the GROUPER field is the
only real accurate way to get it. I don't want to break data out by group
name if I can help it.

I really appreciate all of your assistance on this. Thanks again.

Jay

Jeff Boyce said:
OK, once I've tried various combinations, up to and include copy/paste and
still have a query that fails, I throw the query away and create a new one.

Is this problem showing up with ALL your queries, or only this one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria field,
but no results. I use similar tables every day and have never had this
come
up.
Thanks again for your help

Jeff Boyce said:
Jay

Have you tried using copy/paste to take a value that exists in the table
and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named [GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019".
When
I put this in the criteria field it returns no results. Here is the
SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED
DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


:

Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text) and
get
results.

I'm sure I'm missing something very basic, but I'm at a complete
loss!
Any
help would be greatly appreciated, and let me know if I need to post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
I have a bit of new information that may help. I just tried using a * at the
beginning of the id number I wanted to query and I got results.
Instead of "01301019" I used "*01301019".

At first I thought it may be a problem with the 0 even though this made no
sense to me, but I tried it with an ID number starting with 8 and got the
same results. It only works with a wildcard.

I guess my next question is: Is this an accurate way to query for the data?

Thx again,
Jay

Jay said:
No, it's no problem to start over, but that's what I've been doing. Since
I'm just getting started with this project for my boss I have created new
query after new query. I have even exported the table and re-imported
knowing that this shouldn't matter, but running out of ideas.
I can use other fields to get the data I need, but the GROUPER field is the
only real accurate way to get it. I don't want to break data out by group
name if I can help it.

I really appreciate all of your assistance on this. Thanks again.

Jay

Jeff Boyce said:
OK, once I've tried various combinations, up to and include copy/paste and
still have a query that fails, I throw the query away and create a new one.

Is this problem showing up with ALL your queries, or only this one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jay said:
Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria field,
but no results. I use similar tables every day and have never had this
come
up.
Thanks again for your help

:

Jay

Have you tried using copy/paste to take a value that exists in the table
and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named [GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

All field types in the table are text. It looks something like this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for "01301019".
When
I put this in the criteria field it returns no results. Here is the
SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED
DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


:

Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames, data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text) and
get
results.

I'm sure I'm missing something very basic, but I'm at a complete
loss!
Any
help would be greatly appreciated, and let me know if I need to post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
It sounds as if there are leading spaces (or other non-visible) characters
at the beginning of the data that is stored in the field.

You might try criteria of
"<Space>01301019"
And see if that works. If it does then you will need to decide if you need
to strip out the leading space.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Jay said:
I have a bit of new information that may help. I just tried using a * at
the
beginning of the id number I wanted to query and I got results.
Instead of "01301019" I used "*01301019".

At first I thought it may be a problem with the 0 even though this made no
sense to me, but I tried it with an ID number starting with 8 and got the
same results. It only works with a wildcard.

I guess my next question is: Is this an accurate way to query for the
data?

Thx again,
Jay

Jay said:
No, it's no problem to start over, but that's what I've been doing.
Since
I'm just getting started with this project for my boss I have created new
query after new query. I have even exported the table and re-imported
knowing that this shouldn't matter, but running out of ideas.
I can use other fields to get the data I need, but the GROUPER field is
the
only real accurate way to get it. I don't want to break data out by
group
name if I can help it.

I really appreciate all of your assistance on this. Thanks again.

Jay

Jeff Boyce said:
OK, once I've tried various combinations, up to and include copy/paste
and
still have a query that fails, I throw the query away and create a new
one.

Is this problem showing up with ALL your queries, or only this one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria
field,
but no results. I use similar tables every day and have never had
this
come
up.
Thanks again for your help

:

Jay

Have you tried using copy/paste to take a value that exists in the
table
and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named
[GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

All field types in the table are text. It looks something like
this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for
"01301019".
When
I put this in the criteria field it returns no results. Here is
the
SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED
DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


:

Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames,
data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return
records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for
a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text)
and
get
results.

I'm sure I'm missing something very basic, but I'm at a
complete
loss!
Any
help would be greatly appreciated, and let me know if I need to
post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
That did it! Thanks for the help!

I will get rid of the leading space, but will look for another post in the
forum to try and figure it out.

Thanks again!

John Spencer said:
It sounds as if there are leading spaces (or other non-visible) characters
at the beginning of the data that is stored in the field.

You might try criteria of
"<Space>01301019"
And see if that works. If it does then you will need to decide if you need
to strip out the leading space.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Jay said:
I have a bit of new information that may help. I just tried using a * at
the
beginning of the id number I wanted to query and I got results.
Instead of "01301019" I used "*01301019".

At first I thought it may be a problem with the 0 even though this made no
sense to me, but I tried it with an ID number starting with 8 and got the
same results. It only works with a wildcard.

I guess my next question is: Is this an accurate way to query for the
data?

Thx again,
Jay

Jay said:
No, it's no problem to start over, but that's what I've been doing.
Since
I'm just getting started with this project for my boss I have created new
query after new query. I have even exported the table and re-imported
knowing that this shouldn't matter, but running out of ideas.
I can use other fields to get the data I need, but the GROUPER field is
the
only real accurate way to get it. I don't want to break data out by
group
name if I can help it.

I really appreciate all of your assistance on this. Thanks again.

Jay

:

OK, once I've tried various combinations, up to and include copy/paste
and
still have a query that fails, I throw the query away and create a new
one.

Is this problem showing up with ALL your queries, or only this one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sorry Jeff,
The GROUPER field is correct. I just refer to it as Group ID because
technically that's what it is so the field name is correct.
I have typed manually and copy/pasted the number into the criteria
field,
but no results. I use similar tables every day and have never had
this
come
up.
Thanks again for your help

:

Jay

Have you tried using copy/paste to take a value that exists in the
table
and
paste it into the Selection Criterion grid, or are you typing in the
GROUP_ID?

By the way, your WHERE clause isn't pointing to a field named
[GROUP_ID],
it's pointing to [GROUPER] ... is that correct?

Regards

Jeff Boyce
Microsoft Office/Access MVP

All field types in the table are text. It looks something like
this:

GROUP_ID GROUP_NAME
01301019 XYZ MEDICAL
01301050 ZXY MEDICAL

There are many records with the same GROUP_ID number due to member
information. All I'm trying to do is pull all records for
"01301019".
When
I put this in the criteria field it returns no results. Here is
the
SQL
if
it helps:

SELECT tbl_CHICAGO_HMO_10_5.MARKET, tbl_CHICAGO_HMO_10_5.GROUPER,
tbl_CHICAGO_HMO_10_5.[GRP NAME], tbl_CHICAGO_HMO_10_5.[PCP KEY],
tbl_CHICAGO_HMO_10_5.[PCP NAME], tbl_CHICAGO_HMO_10_5.[PCP PHONE],
tbl_CHICAGO_HMO_10_5.MEMBER, tbl_CHICAGO_HMO_10_5.[MBR ID],
tbl_CHICAGO_HMO_10_5.[MBR DOB], tbl_CHICAGO_HMO_10_5.K1,
tbl_CHICAGO_HMO_10_5.UNRESOLVED, tbl_CHICAGO_HMO_10_5.[UNRESOLVED
DESC],
tbl_CHICAGO_HMO_10_5.K2, tbl_CHICAGO_HMO_10_5.[CMS ACCEPTED],
tbl_CHICAGO_HMO_10_5.[CMS DESC], tbl_CHICAGO_HMO_10_5.[RPT DATE],
tbl_CHICAGO_HMO_10_5.[HIGH DOLLAR MBR]
FROM tbl_CHICAGO_HMO_10_5
WHERE (((tbl_CHICAGO_HMO_10_5.GROUPER)="01301019"));


:

Jay

It all starts with the data ...

Please provide a bit more explanation of your data (fieldnames,
data
types,
...., examples of data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am running what I thought was a very simple query to return
records
based
on a field called ProviderID. The data type is text due to the
possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for
a
provider
I
know is in the table, I get no records.
I have queried every other field in the table (all fields text)
and
get
results.

I'm sure I'm missing something very basic, but I'm at a
complete
loss!
Any
help would be greatly appreciated, and let me know if I need to
post
more
info as I'm new to the forum. Also, I'm using 2003.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top