Error performing UPDATE query

[Kemidan2014]

I created a temporary table using a Make Table query called "Sorttotals" this table using math functions to fill in missing values in a field that should have been filled out in all the records in "ShiftNotestbl"

Trying to perform a simple UPDATE query to update fields "Total" and "Total_b" in Shiftnotestbl to the values of the same field in table "sorttotals" i linked the IDNum fields of the tables together so that the values get placed in the correct record. I recieved a Cannot Join on Memo.. error.

I confirmed that in each table the field TYPE matches so I am not understanding why this update query is faulting.

 

[Joe4]

What is the data type of each field you are trying to join on?
Are the two objects you are joining on both Tables or Queries?
If they are Tables, are these native tables in Access, or are they linked in from somewhere else?

 

[Kemidan2014]

IDNum fields are Long Text
and fields Total and Total_b are Number

Table Shiftnotestbl is a linked table in the back end database
and Table Sorttable is temp table i created in the front end copy i am working in.

 

[Joe4]

IDNum fields are Long Text
and fields Total and Total_b are Number

Table Shiftnotestbl is a linked table in the back end database
and Table Sorttable is temp table i created in the front end copy i am working in.

You cannot join on Long Text (Memo) fields, as the error message tells you.
How long are these fields?
Is there a reason you are not using the normal Text data type (which allows up to 255 characters)?

 

[Kemidan2014]

i was not aware Long text is considered memo.

Not long at all its a 4digit year with hyphen and up to 6 digit number what it looks like the previous creator is doing is simply making a new number using the autonumber field native to the access table and slapping the year the sort was created in front of it with no reset as year changes and using this new IDnum field instead of the autonumber field to serialize

 

[Joe4]

Change the data type to Text, and then try again.