Duplicate Reports Value on reports

[billab0nx]

Hi, i just learn on how to use access.

I tried to create time log, So i create 3 tables
1. tblEmployee (ID, Name)
2. tblStartTime (Date, StartTime(PK), Emp_ID)
3. tblFinishedTime(Date, FinishedTime(PK), Comments, Emp_ID)

My Table relation is Emp_ID as foreign key to tblStartTime and
tblFinished Time.

Now, when i generate report, The table start working just fine the
didn't duplicate the rows, But the Finished table it keep on showing
the previous value, so it will show double.

Can someone help me? i can send the db.

Thank u in advance.

 

[Irene]

how u create your query? may be u can send me your db to me. i will try to
help u.

 

[Duane Hookom]

I would place all times in a single table. Also, Date is a reserved word
since it is a function name. I don't care for using the time fields as a
primary key. I suppose changes are very remote that more than one employee
would have the same exact start or finish time.

If you ask a report question where the data doesn't seem correct, please
post your record source query SQL view.