More than 255 fields management in a Select query of access 2000

[Mike375]

I understand. However......and maybe I'm just not seeing an example that relates to my situation.......what if for the details of the children, you had 255+ different details that you needed to record and produce onto a report......at the end of the day you would have 255+ fields per record (child) that you need to query....at this point would be stuck in having to do subreports to get them all onto a report.

A Gemma has said you would need to split them. The facts are that 255 is the limit.

You will probably find that if you had 300 different pieces of data (which in reality is simply a description of the main entity) then it could be categorised. Even if the data was answers/questions they would still fall into categories. Each category could have its table/query and form.

 

[MSAccessRookie]

Bob - great example. I get it now.

EVERYONE - THANKS - GREAT GROUP EFFORT - YOU BEAT IT INTO MY HEAD.

If you use an 8 pound bag of ice, the lumps on your head will go down pretty quickly. Good luck and come back whenever you need any more lumps*.

*(oops that was supposed to be help)