Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Too many fields when INTO table
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...- jonalso
- Post #3
- Forum: Microsoft: Access Other topics
-
Too many fields when INTO table
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.- jonalso
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
