Duplicate Reports Value on reports

  • Thread starter Thread starter billab0nx
  • Start date Start date
B

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