Display Dynamic # of Rows in SubReport

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top