I am trying to add the contents of certian cells and add them to another cell (temp). i
was using the SQL statement

sqlstr = "SELECT SUM([MFTBM1 FREQ]) AS TEMP FROM RMAP_MODEL
WHERE (RMAP_MODEL.WUC LIKE '" & strInputValue & "*" & "' AND
LEN(WUC)>3)"
WUC Contains 2, 3, and 5 digit numbers. the 5 digit are the ones that i need to sum
and add to the 3 digit. then i have to do the same to the 2 digit. is there something
wrong with my SQL statement? does this even work in Access 2000? i am trying
to execute the SQL command using docmd.runSQL sqlstr. can anyone help me
with the syntax of my expression, or tell me if it will even work in Acess 2k!!
Thanks,
Jason