Access 2007 Reports

[a4jack]

I run a club where different members do different things over the years. I want to print a report of a member, and what he did over the last few years. I have a table with all the members on and another listing all the work done by the members. I am able to use the filter on the work done to arrive at a list for one member's work. I cannot seem to transfer this to a report as the filter is ignored when I try to use the report wizard. any ideas please?

 

[Remou]

You can create a query and base your report on the query, or you can use the wizard to add a command button to print a report. You can then edit the wizard generated code to add a where statement. You should end up with something like:

    stDocName = "rptMembers"
    DoCmd.OpenReport stDocName, acPreview, , "MemberID=" & Me.txtMemberID

The above code would be suitable on a form that showed members.

You will find more information on OpenReport here:

http://msdn.microsoft.com/en-us/library/aa220304(office.11).aspx