[AccessDevelopers] Query gone wild

 

I had a query for a report as follows:

SELECT tbl_Bal.PNL, tbl_Bal.AccNumber, GEN_tmp_Bal.AccDesc, tbl_Acc.TransType, tbl_Key_Dates.RptDD

FROM tbl_Key_Dates, tbl_Bal INNER JOIN tbl_Acc ON tbl_Bal.AccNumber = tbl_Acc.AccNumber

WHERE (((tbl_Bal.PNL)=Yes) AND ((tbl_Bal.AccNumber)<>8200102))

ORDER BY tbl_Bal.AccNumber;

This query has been working fine until yesterday.  It now shows two lines for each account; one with the RptDD and one without.  The latter did not happen before.  

Question: How can I resolve this problem ?  OR What actually happen ?

Regards, jay

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Please zip all files prior to uploading to Files section.

Visit Your Group

• New Links 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___