Re: Multiple occurence of record as there is only one record in table needs help

Eric, what exactly is your question?

Eric wrote:
If you look into data the expr1 not match with CORP but it still shows
multiple records as account4 has only one record

TicketNum Account4 Expr1 LstVldTech TECH
CORP
4376 00000-000000-00 0 123 123 7801
4377 00000-000000-00 0 166 166 7801
4389 7844460546505 78444 323 323 7801
4378 00000-000000-00 0 551 551 7801
4377 00000-000000-00 0 166 166 7802
4389 7844460546505 78444 323 323 7802
4376 00000-000000-00 0 123 123 7803
4389 7844460546505 78444 323 323 7803
4378 00000-000000-00 0 551 551 7803
4389 7844460546505 78444 323 323 7806
4378 00000-000000-00 0 551 551 7808
4376 00000-000000-00 0 123 123 7816
4377 00000-000000-00 0 166 166 7816
4389 7844460546505 78444 323 323 7816
4378 00000-000000-00 0 551 551 7816
4376 00000-000000-00 0 123 123 7818


SELECT LastValidTech.TicketNum, LastValidTech.Account4,
Val(Left([LastValidTech].[Account4],5)) AS Expr1, tech_id.CORP FROM
LastValidTech INNER JOIN tech_id ON LastValidTech.LstVldTech =
tech_id.TECH
WHERE (((Val(Left([LastValidTech].[Account4],5)))<>[tech_id].[corp]));

Thanks.



--
Smartin
.