Appending table by Crosstab - Flexible headers

[Locopete99]

I have a crosstab query that splits and lists an amount of data by month.

The problem is, I dont always have a full year, so when I run the append query, it tells me I can't as some of the headers (months) are missing.

Is there a way to skip this error and just upload a 0 if the month header doesn't exist in the cross tab?

 

[pbaldy]

See if this helps:

http://allenbrowne.com/ser-67.html

 

[plog]

Lots of red flags in your post. What's the end game?

I mean storing data as you have described breaks normalization. You shouldn't have a field for each month's value, instead you should have a row of data for each month and field that designates what month that value is for:

ReportValue, ReportMonth
12, April
98, August
33, December

What are you doing with the data once its in that table?

 

[Locopete99]

Thanks Paul, Just what I needed

 

[pbaldy]

No problem.