Recent content by Bcole

I'm trying to filter my table so that i can make it a query. The data in the Facility is linked to another table with FacName and FacID. When i try to filter the data to create the query from the table, it says type mismatch. It's really bothersome....btw is there another way to create a...

Ok thanks, I'll try that. Another thing, while in design view in tables. How do i filter a data field that has a drop down menu? it keeps saying expression mismatch...

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...

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?

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

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

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...

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...