Big database...multiple SUM within multiple filters within reports?

[Bcole]

Ok. So at work I'm trying to edit this datebase. It has a lot of info and it ALL goes into 1 big database. And the problem is they need to count the fields.
They need it counted by centers(Cities). So I can filters it based on cities, use count (center data field) to get the number of visits. Then i can use sum to figure how many errors were reported that month, etc. But the problem is I don't want to have to use 10 reports for this. What i want is a report that lets me filter every center, then use count and sum once it has been filtered. And then I need all that to show up on 1 report. Not 10 different ones. Thanks, any help would be appreciated!

 

[Bcole]

Ok so I was doing some thinking. Couldn't I just filter each individual center by name into a query? But the concern I have is the query dynamic? Will it update if the main database updates? Also, if i have 2 queries in a report with the same variables. How do I specify the =sum or =count to only do that 1 querie and not EVERY query?

thanks

 

[Rich]

Use the Report wizard, it'll create most of the report for you, just group by city and the use the Where clause of the OpenReport method to filter it

 

[Bcole]

I don't know what the OpenReport method is...or the where clause Are they SQL commands? Or what....


thanks

 

[Bcole]

Ok nevermind...i found the code. My question is where is the code placed ? Do.cmd openreport...part of an object? Will i have to make a form then to be able to use this command?

thanks

 

[Bcole]

Ok, I ran into another problem. The field im trying to apply a filter to is linked to a table already. So it has a drop down box so you can select which center you want in the data on the table. keeps saying type mismatch when i try to apply the filter using the word. Any ideas?