Tables - limit on number of fields?

[mergle]

Does Access2002 limit the number of fields you can insert into a table?

 

[WayneRyan]

mergle,

Don't know about Access 2002, but if your table is approaching
what I think is the limit (255), you should really take another
look at how you're storing your data. That's just way too many
fields.

Wayne

 

[mergle]

I'm starting a design on a homebuilding database and I have 80 job cost items associated with each job record...

I'm trying to determine if I these costs should be fields in a tblJobs table or records in a tblCost table linked thru a JobID...

 

[WayneRyan]

mergle,

They should be in another table, related by JobID. If they are
also comprised of "sub-elements", then another table would
be in order.

You should find it easy to use combo/list boxes for data
entry and searching purposes.

Keep us posted as to your progress.

Wayne