query record limit?

[vientito]

I am a newbie in Access so please bear with my question

I understand that in access records in tables have limits to 255 for fields and 4K bytes for record width after Access2007



However, when I create query from different tables, is there a real limit to the record size and field numbers of this query object? Some of the fields that I am going to list in the query are probably not going to be normalized anyway and may repeat many times. Is query record still bound by a size limit, like what happens to table objects?

[burrina]

Perhaps this can explain. http://www.databasezone.com/techdocs/acclimit.html

HTH