Solved Access Join returns Blank (1 Viewer)

[david147]

Hi,

I have quey1 and query2.

Query1 is select names
Query2 is select names and count of names

When I join Query1 onto Query2 on names (left join or inner) , the many matches that should be there for name returns nothing, I get a blank table.

The names in Qery1 are compiled by a union and the names in Query2 are compiled with a group by, but that shouldn't make a difference if I join Quer1 onto Query2.

Any Idea why showing blank? Do I need to cast fields?

 

[CJ_London]

casting is tsql syntax - are you using sql server? or access?

reason for it showing blank is you are not getting any matches. Not enough information provided to suggest why but a few wild guesses:

one query is using a lookup field in the table and the other is not
names are not spelt the same - perhaps one has initials, the other not, or there are spaces in one and not the other
one query does not return any records