Click here to Skip to main content
15,888,733 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
this is my query which is running correctly when I use sql database.But at present I use access and I write this query same as previously .
select Client_Payment_TB.Bill_ID,Client_Payment_TB.Client_Name,Client_Payment_TB.Bill_Date,Client_Payment_TB.Material_sold,Client_Details_TB.Phone,Client_Payment_TB.Pay_Mode,Client_Payment_TB.Cheque_DD_No,Client_Payment_TB.Bank,Client_Payment_TB.Cheque_Date,Client_Payment_TB.Current_Date,Client_Payment_TB.Discount_Amount,Client_Payment_TB.Total_Amount,Client_Payment_TB.Sum_Of_Total,Client_Payment_TB.Paid,Client_Payment_TB.Remaining from Client_Payment_TB inner join Client_Details_TB on Client_Payment_TB.Client_Name=Client_Details_TB.Client_Name where Client_Payment_TB.Client_Name='" + comboBox_Client_Name.Text + "'";

their are two table that is.Client_Payment_TB and Client_Details_TB

when I execute this then this error msg show-
"IErrorInfo.GetDescription failed with E_FAIL(0x80004005)."
Please help me its urgent..!!
Posted

1 solution

you can try for & in place for '+' sign
Also join shouldn't on name it should be on id
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900