I don't understand why I am getting this message when I try to run a query.
D Duane Hookom Aug 14, 2004 #2 Probably because you have too many fields defined. Can you tell us anything about the tables involved in your query and your SQL view?
Probably because you have too many fields defined. Can you tell us anything about the tables involved in your query and your SQL view?
J John Spencer (MVP) Aug 14, 2004 #3 Is the query by any chance a CROSS-TAB Query? If so, then the crosstab is creating more than 255 columns (in Access 97 and Access 2000). If this is not the problem, can you post the text of your SQL query.
Is the query by any chance a CROSS-TAB Query? If so, then the crosstab is creating more than 255 columns (in Access 97 and Access 2000). If this is not the problem, can you post the text of your SQL query.
