Prev: using "Last" in query desgin
Next: Date serial for 2 months prior
From: Novice2000 on 10 Mar 2010 14:07
I have a ODBC query built to pull data from a table in Access and linked to
another database table.

The query seems to work fine to compare data from the two tables, however
there are a few blank fields displayed in the query. I cannot figure out why
these fields are blank as there is data in the second table. If I try to
enter data it dings and wont let me. It is obviously there, but it not being
displayed in the query.

Any ideas on a fix would be greatlu appreciated.
From: Jerry Whittle on 10 Mar 2010 14:27
What is the data type of the blank fields? There's some things that Access
can't handle.

Is there a left or right join in the query? That could explain it if there
isn't a matching record in one table.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice2000" wrote:

> I have a ODBC query built to pull data from a table in Access and linked to
> another database table.
>
> The query seems to work fine to compare data from the two tables, however
> there are a few blank fields displayed in the query. I cannot figure out why
> these fields are blank as there is data in the second table. If I try to
> enter data it dings and wont let me. It is obviously there, but it not being
> displayed in the query.
>
> Any ideas on a fix would be greatlu appreciated.
From: Novice2000 on 10 Mar 2010 15:49
Thanks Jerry. Some days it doesn't pay to get out of bed. Turns out the
client number in the second table though the query were off one digit due to
data entry mistakes. Once corrected the query pulls back all data. What is it
they say garbage in garbage out. Thanks

"Jerry Whittle" wrote:

> What is the data type of the blank fields? There's some things that Access
> can't handle.
>
> Is there a left or right join in the query? That could explain it if there
> isn't a matching record in one table.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Novice2000" wrote:
>
> > I have a ODBC query built to pull data from a table in Access and linked to
> > another database table.
> >
> > The query seems to work fine to compare data from the two tables, however
> > there are a few blank fields displayed in the query. I cannot figure out why
> > these fields are blank as there is data in the second table. If I try to
> > enter data it dings and wont let me. It is obviously there, but it not being
> > displayed in the query.
> >
> > Any ideas on a fix would be greatlu appreciated.
 | 
Pages: 1
Prev: using "Last" in query desgin
Next: Date serial for 2 months prior