Two Different Functioning Tables into One Report (1 Viewer)

SetanPutih

Registered User.
Local time
Today, 04:45
Joined
Jun 27, 2019
Messages
27
Hi guys,

I need some help please. OK so..

I am creating an annual leave app for my company. I have two tables with different functions. The purpose of the first table is to record annual leave which has been applied for. The fields are..

ID
Employee ID
Holiday year
Branch
First Date Absent
Last Date Absent

The second table keeps a running total of how many annual days each employee has remaining. The number is linked to the name e.g. James, 25.. Once I input the Number of Days Requested it reduces it from the running total. Therefore the table does not create new records, it only modifies the number linked to the name. The fields are..

Employee ID
Employee name
Number Of Days Accrued
Number of Days Requested

Currently, to input an annual leave, both tables are presented in a Form and subform which records the information in two separate tables.

What I'm trying to do is create a report which shows the information from both tables. Unfortunately, due to the clash in functions I don't know how this would be possible.

Does any one have any ideas?

Thank you for taking the time to read this.



Employer
 

isladogs

MVP / VIP
Local time
Today, 11:45
Joined
Jan 14, 2017
Messages
18,186
You should be able to use a report and subreport in a similar way to your form/subform. Link using the EmployeeID field
 

SetanPutih

Registered User.
Local time
Today, 04:45
Joined
Jun 27, 2019
Messages
27
Thanks! I will give it a try. Much appreciated.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:45
Joined
May 7, 2009
Messages
19,169
as IslaDog suggest, create a Query from both tables.
Link both tables using Employee ID field.
select from both tables the fields you want to output in report.
no need subreport.
 

Users who are viewing this thread

Top Bottom