The Numeric Field Overflow error with linked tables

[Sandra M]

Hi,

I have a linked table from Excel and get the error message re Numeric Field
Overflow when I try to run a parameter query on the resultant table in Access.

I have in some ways got round this by creating an update table query and
then running my query with parameters based on the updated table.

Hope this makes sense so far. My problem is that it is very hit and miss and
only works some of the time. As the users who will be running the resultant
report are not particularly IT literate I need it to work consistently.

Any help would be appreciated.

Thanks

Sandra

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[Sandra M]

Hi Jerry,

Sorry it took me so long to get back to you. It is sensitive data so I have
modified slightly the field names and replaced the filtered words with abc
and xyz but the structure is the same. Sheet 1 is the nam of the table which
is linked to an excel spreadsheet. I have found after reading another post
that my query will run once after I compact and repair but the second time I
try to run it will give me the numeric field overflow error - each time I
compact and repair it will run only once.

Many thanks.

Sandra

SELECT sheet1.number, sheet1.[Named Context], sheet1.[number days],
sheet1.area
FROM sheet1
WHERE (((sheet1.[Named Context]) Not Like "*Abc*" And (sheet1.[Named
Context]) Not Like "*xyz*") AND ((sheet1.[number days])>=2))
ORDER BY sheet1.[number days] DESC;