Subject: Many field reporting
Posted By: anukagni Post Date: 9/12/2006 4:13:16 AM
Hi friends,

 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….




    


Bye




Learn as you can..
------------------------
pap...
Reply By: anukagni Reply Date: 9/21/2006 5:08:55 AM
Is this explanation is not understandable..
 

 pls tell me...!

Learn as you can..
------------------------
pap...
Reply By: anukagni Reply Date: 9/27/2006 1:37:11 AM
hi any bdy pls help...

  is this possible

Learn as you can..
------------------------
pap...

Go to topic 50073

Return to index page 164
Return to index page 163
Return to index page 162
Return to index page 161
Return to index page 160
Return to index page 159
Return to index page 158
Return to index page 157
Return to index page 156
Return to index page 155