Strange table

[voiD]

Hello,

I have a strange problem which have to be solved in Access in all way, if it is possible. I have to create a table similar to an Excell sheet. Row headings are name of persons, column headings are workplaces. The aim of this table is to register worked hours at each workplaces per persons. At one person in one shift more workplaces are possible. The number of persons and workplaces is changeable. Does anyone know how could I solve that to store in different records each workhours? For example if a person works 4 hours at 1. workplace and then 4 hours at 2. workplace, this would mean only one row on the form, but two records in the table.
I would be very grateful if somebody would have a good idea! Many thanks in advance!

VoiD

 

[neileg]

One big difference between Excel and Access is that in Excel, the way you store the data is pretty much the way you present the data. In Access it's not.

What you are describing as your table is more likely to be the result of a cross tab query. You need to store your data as a series of records, each one identifying the person, the date, the location and the number of hours. Then the query will organise your data the way you want is so it can be presented in a form or report. Your form for data input will be quite different from your final output.