Too many fields when INTO table

[jonalso]

Trying to do the following:

SELECT qselDemurr.DemurShare AS qDemurrage INTO tblTest2 FROM qselDemurr

It fails with the following error: “Too many fields defined”.

The DemurShare is calculated here:

[DEMURRAGER]/24*[qNetLaytime] AS qDemurrage

The qselDemurr has 100 fields.

 

[dhookom]

Make a copy the table, make some changes, try again.
Make a copy the table, make some changes, try again.
Make a copy the table, make some changes, try again.
Make a copy the table, make some changes, try again.
Make a copy the table, make some changes, try again.
Repeat until you know where the issue is coming from.
When you have figured out the issue, then report back ;-)


Duane
Hook'D on Access
MS Access MVP

 

[jonalso]

But the question is: why am I getting the error message "too many fields" when INTO table? No problems without the INTO. Have tried different NUMBER Data Types on the table-field; Double, Decimal, Long Integer. The output has numbers from 1214728,13987732 to -13500224,7924805. Some rows also returns null.