View Single Post
  #6  
Old January 13th, 2006, 09:34 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default Crosstab query with criteria, dynamic columns and crosstab rep

If you don't know what the column heading are going to be, you probably need
to find some code to dynamically create the report based on the crosstab.

--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"joshblair" wrote:

Jerry,

I appreciate the reply. I'm still fuzzy on your solution. You said to
prepopulate the Column Headings property of the crosstab query but I
don't know this information ahead of time. Maybe I am missing
something, but can you eloborate a bit?

I have been looking for examples but the ones that I have found
require that you know the column ahead of time.

Thanks,

Josh Blair