crosstab query

[cunnie]

Explaination of the problem here


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

 

[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