update query not showing 1 field out of 4

[live2ride]

to start with im not new to queries. i have made many queries and they all work fine form complicated to simple.
now i encountered something i havent encountered before

i have many queries retrieving data and updating tables but im having issues with two of my quries
bottom line is i have a query to make a table and insert data, sort of a temp table which gets deleted afterwards
new table is created and data is inserted, so its working like it should

from new table i have 2 queries updating other tables


in this new table i have 4 fields.
when i click on view update query 3 fields are showing up correctly but last field is not
both tables new and one being updated this field is text field

i tried creating a new query with same results. closing access file and reopening, and nothing changed
anyone has any idea?

[June7]

Think will have to analyse the db. If you want to provide, follow instructions at bottom of my post.

[live2ride]

i was having numerous issues with that file so i created a new file and imported everything, which is working fine now