Suggestions:
1. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General | Name AutoCorrect
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html
2. Use the correct delimiter.
If you open your table in design view, what is the Data Type of the field
that supplies the column headings?
- Text? Add quotes around each value in the Column Headings, e.g.:
"Dan", "Beth", "Jodie"
- Date/Time? Add # around each value in Column Headings, e.g.:
#1/1/2006#, #2/1/2006#, #3/1/2006#
- Number or Currency? Don't use any delimiter in Column Headings, e.g.:
1,2,3,4
3. Try typing the list in SQL View.
If the suggestions above don't fix it, just type a couple of values into the
Column Headings property. Then switch the query to SQL View (View menu) and
add the remaining values there in the PIVOT clause.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mike" <la***********@ gmail.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...
Hi,
Im trying to create a crosstab query with fewer than 255 headings
(about 50), but it crashes when I try to save after writing the heading
names in the query property "column headings". My list is pretty long,
but far from having 255 entries.
I specify which columns I want so that it doesn't give me an error
message because a field has no valid data attached to it.
