A
aaron.kempf
team
so i have a nice little list in sharepoint.. about 15k items
i've got the simplest little join statement in access; and im trying to
UPDATE the sharepoint list via an access query.
so im joining between my access table and then sharepoint list and i
get the infamous 'numeric field overflow'.
i checked the range of everything
both columns are 'choice'-- ie they are prepopulated with the years
from 1960 to 2020
but it just looks like a pretty straight update clause and it's not
working.
1) i have a list named DEVELOPMENT RMTS: ALL Boxes or something; i
renamed this to SP_BOXES
2) a query that pulls from sharepoint; into an Access temp table the
min and max values for a year column (at the box level-- one level
above the file granularity)
SELECT Min(TF03_FID_STBN.[File Inclusion Date]) AS MINYEAR,
Max(TF03_FID_STBN.[File Inclusion Date]) AS MAXYEAR, TF03_FID_STBN.[ST
Box Number]
FROM TF03_FID_STBN
GROUP BY TF03_FID_STBN.[ST Box Number]
HAVING (((TF03_FID_STBN.[ST Box Number]) Is Not Null));
this is flashed from the query named 'QF04_FID_STBN_MINMAX' into a
table named 'TF04_FID_STBN_MINMAX'. When I say flash; i just wrap a
make-table statement on the outside of it and push it into a temp
table.
3) simple query that tries to update the sp list--- this just looks
like it's not working
UPDATE TF04_FID_STBN_MINMAX INNER JOIN SP_ALLBOXES ON
TF04_FID_STBN_MINMAX.[ST Box Number] = SP_ALLBOXES.[ST Box Number] SET
SP_ALLBOXES.[Record End Inclusion Date] = [MINYEAR],
SP_ALLBOXES.[Record Start Inclusion Date] = [MAXYEAR];
I wish i could give you guys more information.. i just need to get this
working; and it's driving me crazy
'numeric field overflow' is the error i get
so i have a nice little list in sharepoint.. about 15k items
i've got the simplest little join statement in access; and im trying to
UPDATE the sharepoint list via an access query.
so im joining between my access table and then sharepoint list and i
get the infamous 'numeric field overflow'.
i checked the range of everything
both columns are 'choice'-- ie they are prepopulated with the years
from 1960 to 2020
but it just looks like a pretty straight update clause and it's not
working.
1) i have a list named DEVELOPMENT RMTS: ALL Boxes or something; i
renamed this to SP_BOXES
2) a query that pulls from sharepoint; into an Access temp table the
min and max values for a year column (at the box level-- one level
above the file granularity)
SELECT Min(TF03_FID_STBN.[File Inclusion Date]) AS MINYEAR,
Max(TF03_FID_STBN.[File Inclusion Date]) AS MAXYEAR, TF03_FID_STBN.[ST
Box Number]
FROM TF03_FID_STBN
GROUP BY TF03_FID_STBN.[ST Box Number]
HAVING (((TF03_FID_STBN.[ST Box Number]) Is Not Null));
this is flashed from the query named 'QF04_FID_STBN_MINMAX' into a
table named 'TF04_FID_STBN_MINMAX'. When I say flash; i just wrap a
make-table statement on the outside of it and push it into a temp
table.
3) simple query that tries to update the sp list--- this just looks
like it's not working
UPDATE TF04_FID_STBN_MINMAX INNER JOIN SP_ALLBOXES ON
TF04_FID_STBN_MINMAX.[ST Box Number] = SP_ALLBOXES.[ST Box Number] SET
SP_ALLBOXES.[Record End Inclusion Date] = [MINYEAR],
SP_ALLBOXES.[Record Start Inclusion Date] = [MAXYEAR];
I wish i could give you guys more information.. i just need to get this
working; and it's driving me crazy
'numeric field overflow' is the error i get