Search results

That works !! Thank you sir, I just know that there are crosstab quey, pivot and transform. Are those exist only in acess or all database? Now i am thinking about dummy date tables and fill it on the fly with the parameters that we supply (populate one column with range of date). Is it...

Thanks for the info :) => Only results the last date of each person.. Actually I have made query Q_PxD (in the database file that I attached yesterday) that created that dummy table but I failed when joining the table. What's wrong with this query? SELECT P.NIK, P.Name, P.Date, T.Time_In...

Edit the tables and attached the database file..

Time attendant program I have table T_Personnel like this +----+------+----------+---------+ | ID | NIK | Name | Dept_ID | +----+------+----------+---------+ | 1 | 1001 | Ann | 1 | | 2 | 1002 | Bond | 1 | | 3 | 1003 | Chan...

After searching and reading for a while i am sure i will get many knowledge from this great forum. Enlighten me please... :)