crosstab

[Nelson Bile]

Hi

I have a query with the following criteria:
>= [Forms]![Main Program]![Text233].[Value]
It workok in the query. But Ihave to questions:
1- What I have to do on the criteria to create a crosstab?
2- What I have to do to make the query as a subform changes as soon as I finish printing the number on the Text233 and clik a mouse or enter or a button rather than presing record navigator.

Regards,

Nelson

 

[AncientOne]

To create a crosstab, you must have Row headings, Column headings and a value. As you don't say what fields you want to summarize, no help can be offered.

On your second request, I don't understand. Do you want to run the query when the field is updated? Please rephrase.