Increase Append & Update query columns (1 Viewer)

Ossama22

Registered User.
Local time
Today, 15:08
Joined
Aug 31, 2018
Messages
52
Hello guys,
I have a question and hope to find answer here, i have a query consists of around 50 column, when i create append or update query and start to select fields to uodate its only allow to append 36 columns. Is there any ways to increase coloumns numbers in the update query to able me to fill my 50 columns?
Thx in advance
 

isladogs

MVP / VIP
Local time
Today, 13:08
Joined
Jan 14, 2017
Messages
18,186

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 08:08
Joined
Feb 28, 2001
Messages
26,996
Concur with Colin regarding the possibility of not being properly normalized.

I have DEFINITELY performed a query with more than 36 fields in it when dealing with a JOIN query that required me to update multiple tables as a single event.

What is the specific behavior that stops you? Tell us in a more detailed manner what you were doing. Like, using the query-grid interface? Did you get an error pop-up? Mechanically speaking, where were you and what were you doing?
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 00:08
Joined
Jan 20, 2009
Messages
12,849
I recall reading that the maximum number of fields in a query is limited to 255. However in an update or insert, all source fields and both before and after values of the destination fields count towards the total.
 

Users who are viewing this thread

Top Bottom