Entering Report Parameters

Becca

Registered User.
Local time
Today, 15:53
Joined
Dec 12, 2001
Messages
58
Hi
I am trying to have a reports query parameters set via a form. However, I am unsure how to get the following:

I want to show statistics against states for a defined year. The state names stay the same, as I have a column for each state name, but I want the report user to be able to define the year to be queried. So far in the query I have the following
Feild Name- NSW: IIf([state/div]="NSW",([2001-02]))
This provides me with all the Statistics assigned against NSW, however, how do I change the year from 2001-02 to 2000-01 via a form parameter?

Any suggestions would be appreciated.

Thanks
 
The best way to go about this is to create a parameter query, to select the year. Then create a report based on that query. When you open the report it will prompt you to enter the year you would like to view.
 
Thanks

I was thinking a parameter query, however I am unsure how to do this on this occassion. I am currently entering the following:

Year: [Please Enter the Financial Year for Examination]

However, when I enter "2001-02" I have a string return of "2001-02" for the entire column, when what I want is the corresponding statistics entered agianst that year (each financial year has a column in the original table eg 01-02,02-03,03-04)for each line item. I don't know if I am making much sense here. please let me know if you require more information.
Thanks
 

Users who are viewing this thread

Back
Top Bottom