Crosstab question 1

[jgarnick]

I have a crosstab query that is based on a select query that combines two tables. I also have an append query that appends the results from the crosstab query to a table. The problem I am having is if a particular item that is being counted equals 0 (ie no records with that descrip)in the crosstab query, my append query bombs out, because there is not a field in the crosstab query for the "0" item. Is there a way to drop a 0 in if the field doesn't exist in the crosstab query?

Thanks!

jgarnick
jgarnick@aol.com

 

[Telsa]

What are your column rows? Are they dates? Then yes, you can... I do it all the time.

If not, try this anyway... when you have the query in Design Mode, right click and select Properties. Then in the COlumn Headings, type the headings out that appear in the columns.

Then run it

HTH and hope it works!

Mary )

 

[jgarnick]

Thanks Telsa! I actually have done that in the past and forgot about it--as soon as I read your posting, it all came back to me!! Thank you--it worked and it wasn't date fields either--FYI--

jgarnick
jgarnick@aol.com