Indexing Query

C

Cranky

Hi

I've been messing around trying to change some stats sheets from Excel
to an Access equivalent.

The information would be in a columnar form, with 5 columns and 13
rows, 65 fields in all. When I first set this up, I kept getting error
messages because of duplicate records. I then went through and changed
each field to Duplicates OK. This in turn brought up the message that
there were too many indexed fields.

Although I'm only playing with the system, I am interested in how to
resolve this because it may help with something else I'm working on.
The only way I could think of was to have 1 table for each field, eg
0830 - 1000, waiting <5 minutes = 1 textbox; 0830 - 1000, waiting time
6 - 10 minutes = another textbox.

Is there a better, more sensible solution to this?

Steve
 
C

Cranky

The only way I could think of was to have 1 table for each field, eg
0830 - 1000, waiting <5 minutes = 1 textbox; 0830 - 1000, waiting time
6 - 10 minutes = another textbox.
Click to expand...

uh... 'textbox' above should read 'table.' Cuh.

Steve
 
C

Cranky

There would be five time bands during the day: 0830 - 1000, 1001 -
1200, 1201 - 1400, 1401 - 1600 and 1601 - 1715.

There would be 13 rows in each time band to record the total duration
of each visit. Each row corresponds to visit duration in increments of
5 minutes: 1 - 5 minutes, 6 - 10, 11 - 15, 16 - 20 and so on, up to 61+
minutes.

I know this is a straightforward Excel spreadsheet - which is how it is
recorded now - but I just wondered how it could be done in Access.

Thanks

Steve
 
Top