Ok so heres the deal. I'm working for a company now that already made an Access database. Its pretty primitive in that it has almost 0 relationships through tables. It has ALL the data on 1 huge table. Every new data entry is a visit to a facility.
Right now I'm trying to count the number of visits. Which i can do with the count paramater. But im trying to count each visit to each seperate facility. Which seems easy enough, just filter out the facility. But the problem is the facility is linked to a table with data facility id and facility name. So whenever i try to filter it it says type mismatch?
Also, If this works then i would have to print 100 reports to get all the numbers I needed. How can i make it so that it filters everything else out but 1 facility, does the count and sum opperations i need, then unfilters and refilters a different facility in the same report.
Hope i made everything clear....
thanks in advance!
Right now I'm trying to count the number of visits. Which i can do with the count paramater. But im trying to count each visit to each seperate facility. Which seems easy enough, just filter out the facility. But the problem is the facility is linked to a table with data facility id and facility name. So whenever i try to filter it it says type mismatch?
Also, If this works then i would have to print 100 reports to get all the numbers I needed. How can i make it so that it filters everything else out but 1 facility, does the count and sum opperations i need, then unfilters and refilters a different facility in the same report.
Hope i made everything clear....
thanks in advance!
