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....
|