Split time across multiple brands in a timesheet database

[accessmatt]

Hey I'm working on a database with a form input to record my time on projects at work. Can anyone help me figure out how to split End Time - Start Time among all brands that I've chosen for a line item? Hoping the example (linked below) will help provide clarity about what I'm trying to do.




https://onedrive.live.com/redir?resi...=file%2c.accdb

[June7]

If you want to break up a period of time to multiple brands for each line item then need to enter a record for each brand/line item.

The Brand/Indication field is a multi-value. I NEVER use multi-value fields. I doubt multi-value field will be helpful in achieving what you want.

Time and attendance database is one of the more difficult to build.

[accessmatt]

Thanks for that June7. Is it possible to create multiple unique rows using a form entry? Second, is it possible to auto-divide time among brands like I want to do? Any help you could provide would be appreciated!

Thanks much,

If you want to break up a period of time to multiple brands for each line item then need to enter a record for each brand/line item.

The Brand/Indication field is a multi-value. I NEVER use multi-value fields. I doubt multi-value field will be helpful in achieving what you want.

Time and attendance database is one of the more difficult to build.

[June7]

That automation behavior would require VBA code.