Customer reporting

[joshmadgwick]

Hi All,

Having not played in Access since high school days, I am a bit of a newbie again.
I have created a simple customer database, and now looking at reporting.



I have the high level reports sorted out, but want to create a report where by a customer can be selected by and a report generated for all transactions that have occurred with that customer.
What is the easiest way to do this???

much appreciated!!!!!

[June7]

Options:

1. dynamic parameterized query

Review: http://www.datapigtechnologies.com/f...mtoreport.html

2. code (macro or VBA) applies filter to report when it opens, VBA example:

DoCmd.OpenReport "report name", , , "CustID=" & Me.CustID

[joshmadgwick]

Thanks will have a look and see how I get on