How to structure lots of fields as one record.

[Cboggie]

Hi,I am trying to setup my tables, but before I started, is like some guidance on how to set them up. Here's the plan:
Each day, a person will enter about 200 values in a form. Currently they enter them in a spreadsheet. With that being said, each employees entries will count as one record/occurence for that day/shift. For example the fields might be: name, date, shift, tag1value, tag2value, tag3value, etc etc, - tag180value. These are filled out each day and later on, I will want to search this day and be able to see the form with all these values filled in. Also, I may add/change the entry names occasionally. Ideally, I would like a table named "tags" that I could add and change and the form would pull everything into, however I didn't think this was doable.
Anyone have any suggestions/solutions.

[xladept]

Check out the User Defined Types aka UDT's. With a UDT aka data structure you can do exactly what you describe.

Type Tageroo
Name As String
Date As Date
Shift As String
Tag(180) As String
End Type

Dim T() As Tageroo

at the top of a module under Option Explicit

[JosephP]

it sounds to me like you want
employeeID
date
shift
tag#
tag_value

as the actual table fields.

[Cboggie]

Xladept - I'm still looking into your suggestion. Thanks

Joseph - are you referring to using that table as a lookup column? I will have 180+ entries in that table logged twice daily.

[xladept]

You're welcome. Should you want to post an example, I could spend some time on it tomorrow.

[Cboggie]

You're welcome. Should you want to post an example, I could spend some time on it tomorrow.

I have just started, but maybe having some data will bring more clarity.

Basically, the employee will fill out "Gly Shift Log" each shift. I have 20 or so lines for them to fill out, there will be quite a bit more.

Thanks

[xladept]

Hi Cboggie,

I haven't got a compatibility pack for ACCESS - I guess I can't help you, but the VBA for UDT's is still relevant.

Perhaps an ACCESS expert will help you.