Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

CANNOT CREATE A REPORT ON CROSSTAB QUERY

5 views
Skip to first unread message

Ophara Ohiyana

unread,
Feb 18, 2022, 12:30:47 AM2/18/22
to
I have an Access application that has been running for years now. It's a payroll system. There's a query (let's call it Query3) that pulls data from 2 crosstab queries. Everything worked fine until I introduced a parameter in the crosstab queries. The parameter refers to a date on a form. Now I can't create a report with Query3 as its record source. When I use Report Wizard and I select Query3 as its record source the field names are not displayed. I have a sub that programmatically creates a report based on Query3 but now with the parameter, this fails too. I'm really stumped. Is there any workaround? Thanks in advance for your help.
0 new messages