Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-03-2019, 05:06 AM   #1
SetanPutih
Newly Registered User
 
Join Date: Jun 2019
Posts: 21
Thanks: 14
Thanked 0 Times in 0 Posts
SetanPutih is on a distinguished road
Two Different Functioning Tables into One Report

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

SetanPutih is offline   Reply With Quote
Old 07-03-2019, 05:26 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,447
Thanks: 106
Thanked 2,535 Times in 2,328 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Two Different Functioning Tables into One Report

You should be able to use a report and subreport in a similar way to your form/subform. Link using the EmployeeID field
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-03-2019, 06:07 AM   #3
SetanPutih
Newly Registered User
 
Join Date: Jun 2019
Posts: 21
Thanks: 14
Thanked 0 Times in 0 Posts
SetanPutih is on a distinguished road
Re: Two Different Functioning Tables into One Report

Thanks! I will give it a try. Much appreciated.

SetanPutih is offline   Reply With Quote
Old 07-03-2019, 06:18 AM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,203
Thanks: 57
Thanked 2,313 Times in 2,219 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Two Different Functioning Tables into One Report

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.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DCount not functioning Design by Sue Modules & VBA 12 07-07-2014 06:49 AM
Form Not Functioning . . Evagrius Forms 4 07-12-2010 06:42 AM
Cmd Button Not Functioning Correctly quest4 Forms 2 08-06-2008 08:06 AM
Do While loop not fully functioning Malcy Modules & VBA 5 10-29-2003 01:17 AM
Tab order in subform not functioning Anitali Forms 1 08-06-2002 04:18 PM




All times are GMT -8. The time now is 03:24 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World