Many field reporting
I got an Access DB table with the following fields ,
Program Title, Start Date, End Date.
I want to create an report through this three field and I did as follows :
First I create an from with the above fields and I created an query with the above field in the criteria I have given as [from]![from Name].[depending fields]…
And what I want is I want to set the Program Tile (Combo Box) , Start Date (Text box / List Box) and End Date (Text box / List Box) and all the three as default value as “*”.
And an command button to get the report…
When I click the command button without any selecting the from then it should give all report and when I select an particular program title only then it should show the report by program title wise and when kept the program title as “*” as default value and given start date and end date its should give according to my option .
• But the Query , From and the Report are only one …
If ur not able to understand pls revert me….
Learn as you can..