No Data Return

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carly Access - 20 Nov 2007 02:41 GMT

I ran a query based on two tables and joined them with 2 meaning match what
is in table one with what is in table two. One column from the first table
appeared but data from the second table came back blank, all rows matched,
but the actual data did not. Anyi deas?

Signature

Carly(access fan)

Reply to this Message

Ken Snell (MVP) - 20 Nov 2007 03:02 GMT

Post the SQL statement of the query that you are using.

Signature

Ken Snell
<MS ACCESS MVP>

>I ran a query based on two tables and joined them with 2 meaning match what
> is in table one with what is in table two. One column from the first
> table
> appeared but data from the second table came back blank, all rows matched,
> but the actual data did not. Anyi deas?

Reply to this Message

Carly Access - 20 Nov 2007 03:10 GMT

Hi ken,

THKS, I will provide it for you tomorrow, it's at work.

Carly

Signature

Carly(access fan)

> Post the SQL statement of the query that you are using.
>
[quoted text clipped - 3 lines]
> > appeared but data from the second table came back blank, all rows matched,
> > but the actual data did not. Anyi deas?

Reply to this Message