To Query or not to Query??
in [Reports]
|
From: TheLee via AccessMonster.com on 10 May 2010 19:38 Hello all - I'm a newbe to Access but have made great progress. I'm using Acess 2003. The db is up and running prefectly. Now I need to tackle the reporting. I have seen posts about reports and queries and am a little confused. Do I need to create a query to run my reports off of? I have a tabbed subform in the main form. There are seven tabs breaking up all the services we provide. Like "Promo Items", "Leads", "Client Printed Material","Internal Print Material" and so on. The main form has the User, Branch and Marketing Rep. I need to write two main reports types using a date range. One for the marketing reps that shows the detail of the tabbed subform for each tab. Any given order may have entries in multiple tabs. The other would show production of the users. I have extensive experience writting reports in Crystal and SSRS but it seems Access is a little different. Any direction is greatly appreciated. Thanks - Lee -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1
From: Duane Hookom on 10 May 2010 23:37 I would expect your report design will depend on your table structures. Typically you would use subreports similar to how you might use subforms. There are link master/child properties on subreport controls just like subforms. -- Duane Hookom MS Access MVP "TheLee via AccessMonster.com" <u59624(a)uwe> wrote in message news:a7d14089569fd(a)uwe... > Hello all - > I'm a newbe to Access but have made great progress. I'm using Acess 2003. > The > db is up and running prefectly. Now I need to tackle the reporting. I have > seen posts about reports and queries and am a little confused. Do I need > to > create a query to run my reports off of? I have a tabbed subform in the > main > form. There are seven tabs breaking up all the services we provide. Like > "Promo Items", "Leads", "Client Printed Material","Internal Print > Material" > and so on. The main form has the User, Branch and Marketing Rep. > > I need to write two main reports types using a date range. One for the > marketing reps that shows the detail of the tabbed subform for each tab. > Any > given order may have entries in multiple tabs. The other would show > production of the users. > > I have extensive experience writting reports in Crystal and SSRS but it > seems > Access is a little different. > > Any direction is greatly appreciated. > > Thanks - > Lee > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1 >
|
Pages: 1 Prev: Access 2007 Runtime Report Issue Next: To Query or not to Query?? |