crosstab query

[cunnie]

Explaination of the problem here


[This message has been edited by cunnie (edited 05-13-2002).]

 

[Pat Hartman]

Crosstab queries are very sensitive to parameters whether they are specified in the crosstab query or a query that is used to build the crosstab.

Try changing the paramater query so that it specifically defines the parameters. Right click on the grey background and choose parameters. Enter the two parameters (copy and paste is best since these names must be an exact match) and their data types.

 

[cunnie]

I've got the crosstab working now, I needed to set the parameters data type to Value instead of Text (in the parameter query). I guess this is because i'm referencing the value of the text box and not its text, makes sense in a strange access kinda way.

[This message has been edited by cunnie (edited 05-17-2002).]

 

[cunnie]

Ok, The problem I've got now is that I want the croostab query to be shown in a sub-form on the servicesheet form. The query works on its own, but when i try and create a form based on the query it doesn't give me any fields to add, so no data is shown.

I'm pretty sure I've done this before, but don't remember doing anything special to make it work, any ideas?

cheers

 

[Rich]

You can't add data into a crosstab, only display it, is that what you want to do?

 

[cunnie]

yeah I just want to show the crosstab

 

[Rich]

Just drag the query onto the form, should work.

 

[cunnie]

Yeah thats what I thought, but i did it and the sub-form comes up with no control source. If I try and create it with the wizard when i asks for what fields I want to include, it doesn't show any in the available fields list. The other day I managed to get an error message (don't remember what I did now), something like 'The query you have selected has no output fields or is spelled incorrectly...'

Hope someone can help
Thanks,
cunnie