M
Megan
Hi
I'm trying to create a dynamic cross tab query. Is that possible.
I'm going around and around
I am trying to create a pricesheet for an individual customer that has a selection of products with different sizes.
I created a cross tab query using first per Allen Brownes instructions. That works, but I can only do it with all of the price tiers.
I want to be able to pass in an individuals' pricing tier.
I also have separate categories for the products and would like to separate those out if possible. They each have different sizes and I don't want to have to display all sizes for all products.
I know this is complicated for this small amount of information, but if anyone can help...
I tried to do individual queries using a macro but can't seem to pull that into a report. If I put a criteria say from a form, it tells me it's not valid when I get to the cross tab portion.
In addition, my macro never stops running. I'm sure I'm missing some close or end
Thanks again
I'm trying to create a dynamic cross tab query. Is that possible.
I'm going around and around
I am trying to create a pricesheet for an individual customer that has a selection of products with different sizes.
I created a cross tab query using first per Allen Brownes instructions. That works, but I can only do it with all of the price tiers.
I want to be able to pass in an individuals' pricing tier.
I also have separate categories for the products and would like to separate those out if possible. They each have different sizes and I don't want to have to display all sizes for all products.
I know this is complicated for this small amount of information, but if anyone can help...
I tried to do individual queries using a macro but can't seem to pull that into a report. If I put a criteria say from a form, it tells me it's not valid when I get to the cross tab portion.
In addition, my macro never stops running. I'm sure I'm missing some close or end
Thanks again