Query not returning results for a text field

J

Jay

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
 
J

Jeff Boyce

Jay

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

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
 
J

Jay

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"));
 
J

Jeff Boyce

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...
 
J

Jay

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...
 
J

Jeff Boyce

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...
 
J

Jay

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...
 
J

Jay

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...
 
J

John Spencer

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...
 
J

Jay

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...
 

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

Similar Threads

Append Crosstab Query to Existing Table 0
ASK Field Formatting 1
Report Group Footer DLookUp 0
Query Returning Multiple Results 1
Finding the right style field in VBA 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Finding the proper style field and the numbered paragraph value within the style 0
dynamic calculated field in query 3

Top