MadAtMicrosoft
Registered User.
- Local time
- Today, 07:10
- Joined
- Sep 27, 2010
- Messages
- 18
I'm relatively new at Access.
I previously posted a tread regarding Tips and am going about it in a different way now.
*******************************************************
Background
First, I know everyone never reports all their tips. That part isn't MY problem. I am trying to create a way for employees to report whatever it is that they report. That is all my responsibility is.
Employees must (used loosley) report all tips they received. THEN, they must report if they "Shared" any of that gross tip with another Employee.
An employee will most always only report their "Actual Tips" once per day in the aggregate. (As opposed to posting individual tips received). However, they may "Share" those tips with multiple people during a day.
*********************************************************
I have 3 tables to meet this goal.
A) tblEmployees
B) tblActualReportedTips
C) SharedTips
*********************************************************
+ tblActualReportedTips has a relationship to tblEmployees via EmployeeID (One to Many)
+ tblSharedTips has a relationship to tblActualTipsReported via ActualTipsReportedID (One To Many)
*****************************************************
I first created two queries to total:
********************************************************
THE PART THAT ISN'T WORKING
I then took those two queries and tried to create a 3rd query that would give me the complete information that shows BY EMPLOYEE BY DAY, the Total Tips Received and ALSO the Total Tips Shared.
HOWEVER, if an employee has NO INFORMATION from query "tblSharedTips" That person or Day is left out of the new query.
Am I missing a Null setting ????
I AM COMPLETELY CONFUSED why it won't show it with a Zero (0) for someone that has no "SharedTips" instead of just leaving them off altogether.
Any thoughts?
I previously posted a tread regarding Tips and am going about it in a different way now.
*******************************************************
Background
First, I know everyone never reports all their tips. That part isn't MY problem. I am trying to create a way for employees to report whatever it is that they report. That is all my responsibility is.
Employees must (used loosley) report all tips they received. THEN, they must report if they "Shared" any of that gross tip with another Employee.
An employee will most always only report their "Actual Tips" once per day in the aggregate. (As opposed to posting individual tips received). However, they may "Share" those tips with multiple people during a day.
*********************************************************
I have 3 tables to meet this goal.
A) tblEmployees
B) tblActualReportedTips
C) SharedTips
*********************************************************
+ tblActualReportedTips has a relationship to tblEmployees via EmployeeID (One to Many)
+ tblSharedTips has a relationship to tblActualTipsReported via ActualTipsReportedID (One To Many)
*****************************************************
I first created two queries to total:
1 ) from tblActualReportedTips - Total BY Employee BY Day the ActualReportedTips;
2) from tblSharedTips - Total BY Employee BY Day the SharedTips
This part works fine.2) from tblSharedTips - Total BY Employee BY Day the SharedTips
********************************************************
THE PART THAT ISN'T WORKING
I then took those two queries and tried to create a 3rd query that would give me the complete information that shows BY EMPLOYEE BY DAY, the Total Tips Received and ALSO the Total Tips Shared.
HOWEVER, if an employee has NO INFORMATION from query "tblSharedTips" That person or Day is left out of the new query.
Am I missing a Null setting ????
I AM COMPLETELY CONFUSED why it won't show it with a Zero (0) for someone that has no "SharedTips" instead of just leaving them off altogether.
Any thoughts?