C
ChuckW
Hi,
I have built a main form that has customer information
such as address and e-mail. I then built a series of
queries. The first is a union query which pulls data
from two transactional tables. The second is a crosstab
query the sums the quantities for all products. The third
sorts them from higest to lowest. I then created a
subform based on the third query with the field
CustomerName, Item Name, and Quantity. I bound it to the
main form using CustomerName which is in both.
When I try to run the form I get a message that says "You
can't use a pass through or non fixed column cross tab
query as a rcord source for a subform or subreport.
Before you bind the subform or subreport to a crosstab
query, set the querys column heading property." I can't
figure out what setting I need change. Can anyone help?
Thanks,
Chuck
I have built a main form that has customer information
such as address and e-mail. I then built a series of
queries. The first is a union query which pulls data
from two transactional tables. The second is a crosstab
query the sums the quantities for all products. The third
sorts them from higest to lowest. I then created a
subform based on the third query with the field
CustomerName, Item Name, and Quantity. I bound it to the
main form using CustomerName which is in both.
When I try to run the form I get a message that says "You
can't use a pass through or non fixed column cross tab
query as a rcord source for a subform or subreport.
Before you bind the subform or subreport to a crosstab
query, set the querys column heading property." I can't
figure out what setting I need change. Can anyone help?
Thanks,
Chuck