Tips for displaying or entering calendar based data?

Hi guys

I would like to collect and report on calendar based data. E.g. data with limited attributes but where I want to display it in a nice calendar.

e.g. I have a database table called timesheet. The date field is unique and I have columns for location and hours.

How can I display this information in a report/form in a nice calendar layout with ideally the option to modify the location and hours values.

Basically I need a multi-record display but in a form layout (as opposed to a table layout). If that is possible I can probably write a marcro to move the fields in the right place.

I need a multi-record display but in a
form layout (as opposed to a table
layout)

This functionality, called “Continuous forms” in MSAccess, is not available in Base. The closest to the layout that you want is to make use of grid controls. F.i. for a weekly timesheet, put each task in a separate row and day-in-the-week as columns. Feasible for displaying the data in a specific week, more difficult to manage for data updates.

Success.
JPL