Hi everyone!
I am working on a new worktime logging module for our company database. I would like the layout to show 1 week at the time, with the ability to enter the elapsed worktime from each weekday to the same line / record.
I have attached a simplified copy of the db, which shows what I'm looking for.
The problem is, for some of the required reports, I need the specific dates for performed work.
Is there a way, to maybe have a query calculate the dates, and output them as single records?
..or maybe there's another way to make the weeklog form, without using weekday fields?
Any help is very appreciated!
I am working on a new worktime logging module for our company database. I would like the layout to show 1 week at the time, with the ability to enter the elapsed worktime from each weekday to the same line / record.
I have attached a simplified copy of the db, which shows what I'm looking for.
The problem is, for some of the required reports, I need the specific dates for performed work.
Is there a way, to maybe have a query calculate the dates, and output them as single records?
..or maybe there's another way to make the weeklog form, without using weekday fields?
Any help is very appreciated!
Last edited:
