ontopofmalvern
Registered User.
- Local time
- Today, 15:39
- Joined
- Mar 24, 2017
- Messages
- 64
Hi
I have a report which I want to use a CrossTab query with parameters as the recordsource.
I have found that the only way I can get the parameters into crosstab query is in code (no problem there), but I cannot get the SQL accepted as recordsource. e.g.
me.RecordSource = strCrossTabQuery doesn't work on reports (or at least I can't get it to, it works for me on forms)
I have found that as long as i don't use paramenters I can use the crosstab query as the source for a simple "SELECT * FROM qryCrossTab" query that I can use that as my recordsource on report.
I have tried to set Report recordsource to a recordset which I believe is something Access won't allow (again it does I isn't working for me)
Any pointers where I can take this.
Tah
I have a report which I want to use a CrossTab query with parameters as the recordsource.
I have found that the only way I can get the parameters into crosstab query is in code (no problem there), but I cannot get the SQL accepted as recordsource. e.g.
me.RecordSource = strCrossTabQuery doesn't work on reports (or at least I can't get it to, it works for me on forms)
I have found that as long as i don't use paramenters I can use the crosstab query as the source for a simple "SELECT * FROM qryCrossTab" query that I can use that as my recordsource on report.
I have tried to set Report recordsource to a recordset which I believe is something Access won't allow (again it does I isn't working for me)
Any pointers where I can take this.
Tah