Can't make filter crosstabquery via criteria->build->forms-> Loade

B

Bobi

Hi
When I create a crosstabqyery baseded on a query that includes a filter:
Criteria->Build->Loaded Forms->"form name"->"field name":
forms![formname]![txt_box_name]
I get the error:
"the microsoft het database egnine does not reconize "... " as a vaild field
name or expression."

How can I filter the pivot table, based on a value in a txtCtrl on my loaded
form.

Best regards
Bobi
 
B

Bobi

Hi Allen

Thanks for your reply. I was just about to post the link to you webpage
myself, as I found it via google.

Thank you again for a good keen explanation and an extreme fast answer.

Bobi




Allen Browne said:
In a crosstab query, you must declare the parameter.

Explanation in:
Crosstab query techniques - Handle parameters
at:
http://allenbrowne.com/ser-67.html#Param

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Bobi said:
Hi
When I create a crosstabqyery baseded on a query that includes a filter:
Criteria->Build->Loaded Forms->"form name"->"field name":
forms![formname]![txt_box_name]
I get the error:
"the microsoft het database egnine does not reconize "... " as a vaild
field
name or expression."

How can I filter the pivot table, based on a value in a txtCtrl on my
loaded
form.

Best regards
Bobi
Click to expand...
Click to expand...
 
B

Bobi

Declaring the parameter made my Pivot table work, so thats good. But then
when I try to use the pivot table on a form I got a new problem:

I add the link to the pivot table like this in the form:
Data->Source Object: Query.qry_WAN_Crosstab2

Then i got this error:
Too frew parameters. Expected 1.

How and where do I add the parameter to the Source Object.
Best regards
Bobi
 
A

Allen Browne

Perhaps someone else can suggest a solution here.

Declaring the parameters works or crosstabs (as per your subject line), if
not for pivot tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with 1 Query with Criteria feeding another query 3
how do i make a chart based on a query with a criteria 1
Crosstab Query - External Criteria 10
Help with filter issues? 2
Query problem using form text box for criteria 3
2 Questions; 1 Frustrated User...Form Filter & Query 2
problem with criteria in query 3
Multiple Report Filter using form 1

Top