hi...



i am developing a program and access is the database that i choose as backend. i am having a trouble on using the data report. i have 3 tables and all of them are linked by the employee id



table1-consist of names

table2-consist of their charges(amount)

table3-consist of their payment in charges



below is the sample query that i made to linked the 3 tables



"Select table1.*,table2.*,table3.* from (table1 INNER JOIN table2 on table1.eeid=table2.eeid) INNER JOIN table3 on table1.eeid=table3.eeid where table1.eeid="string""



i set the connection of data report on the ff:

set datareport.datasource=recordset



and i also set the datafield of the textbox inside the data report.



when i execute the program, the system doesn't give me an error but the data report show no data on every datafield.



what could be my mistake. please help...



thanks....