K
Kate
Hello -
I am new to Access - I have done reporting via Jasper and regular SQL,
but I think this is clouding my thought processes. Here is what I am
trying to do:
Enter a value for a combination of values across sub-categories. I
will explain.
All employees are in a Group. For each Group-Employee Combination
(they can be in multiple categories) - I need to enter their
availability by time period - hopefully by selecting an employee/group
combination on a main form, and then a sub-report will populate with
all available time periods and text entry boxes for each of these.
Data is organized into the following tables:
Employee Table (ID, Name, etc.)
Group Table (ID, Name, etc.)
Group Membership (autonumber PK, EMP.ID, Group.ID)
Time (Time Period ID, Year, Month, Year-Month Concatenated Field)
Allocations Table [where I want to store the data] - (Autonumber PK,
Membership PK, Time Period ID, Hours)
I'm not sure how to populate a sub-report to display ALL time periods
along with text boxes on the bottom, is this even possible?
Thank you for your assistance, please let me know if I have not
explained appropriately.
Kate
I am new to Access - I have done reporting via Jasper and regular SQL,
but I think this is clouding my thought processes. Here is what I am
trying to do:
Enter a value for a combination of values across sub-categories. I
will explain.
All employees are in a Group. For each Group-Employee Combination
(they can be in multiple categories) - I need to enter their
availability by time period - hopefully by selecting an employee/group
combination on a main form, and then a sub-report will populate with
all available time periods and text entry boxes for each of these.
Data is organized into the following tables:
Employee Table (ID, Name, etc.)
Group Table (ID, Name, etc.)
Group Membership (autonumber PK, EMP.ID, Group.ID)
Time (Time Period ID, Year, Month, Year-Month Concatenated Field)
Allocations Table [where I want to store the data] - (Autonumber PK,
Membership PK, Time Period ID, Hours)
I'm not sure how to populate a sub-report to display ALL time periods
along with text boxes on the bottom, is this even possible?
Thank you for your assistance, please let me know if I have not
explained appropriately.
Kate