Printable View
i have to design a data report in vb 6.0 that will display all the employee and also their corresponding time comsume in time tracking system.
how can i handle the time of employee so that the display in the data report will be arrange and using only the "app.path" for the data base. i use MSAccess only.
how can i combine the 2 related tables from the same access database.
hope you will help me solve my problem...
i find it hard for me... plsss help me...:(
Research on ADO and SQL, then on data report sections and controls. It will be hard to explain what you need to do unless you understand the terminologies and concepts involved. There are no shortcuts... unless you intend someone else to do it for you.
Moved to Reporting
Here are two ways,
1. Creatre a DataEnvironment as the reports datasource with a Command and a Child Command using the Employee ID to relate the to tables.
2. Use an ADO recordset as the reports datasource. The SQL would use a "join" that creates a recordset that has the data from both tables.
I would not use the "1" method if this a multiuser system.
Don't use it period. It's a nightmare to maintain when queries need to change or underlying schema changes. Hence post #2.Quote:
Originally Posted by wes4dbt
You can use the inner join sql command..Quote:
how can i combine the 2 related tables from the same access database
Greg
:):(:o:DQuote:
Originally Posted by sicnarf
The question has been answered in posts 2 - 6. Do you have additional questions? If so, what?