Pivot chart report

[Guest]

Hi all,

I have query that looks like this:
Language SL date
Italian 60 20/10/2006
French 90 21/10/2006
Italian 70 23/10/2006
Italian 100 24/10/2006
Italian 80 25/10/2006

I have a form with two date boxes: "from" and "to","language" box and a
button "go", i want to specify a certain date in the box "from" and "to" to
view a pivot chart report for the selected language,

Please help

 

[Guest]

Hi Pietro,

Use criteria in a query that get the values from your open form. Something
like this in query design view:

Field: Language
Table: YourTableName

Criteria: =[Forms]![NameOfOpenForm]![NameOfTextBoxControl]


Field: Date <---This is a reserved word, and should not be used!
Table: YourTableName
Criteria: Between [Forms]![NameOfOpenForm]![txtBeginDate] AND
[Forms]![NameOfOpenForm]![txtEndDate]

This last criteria is all on one line. Open your Pivot Report that is based
on this parameter query using the command button's click event procedure.

I'm going to call it a night now, so someone else can hopefully step in, if
you have further questions.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________