By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

Access crashes in crosstab query

P: n/a
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.

Has anyone ever come across this bug before?

Thanx,

Mike

Nov 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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*********************@i42g2000cwa.googlegro ups.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.

Nov 4 '06 #2

P: n/a
Thanx alot for your help, unchecking these options solved the problem!

Nov 6 '06 #3

P: n/a
Excellent, Mike.

Another one goes down the the amazing Name AutoCorrupt issue.

--
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**********************@i42g2000cwa.googlegr oups.com...
Thanx alot for your help, unchecking these options solved the problem!

Nov 6 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.