Recent content by Ibero

Ah yes, you are right. I'm being kicked out of the building now but I will play around with this some more according to what you're saying. I think I over-thought about this last part. I will check back if I have another question after bringing the fields in. Cheers!

Thanks! You have been infinitely helpful... One last thing, I pretty much have everything I really need working, I'm just wondering about this discrepancy while playing with my options. What is the difference between this query: SELECT Visits.[Case Number]...

Great! That one works nice, I now have unique beneficiaries for clients that visited in 2011. You mentioned to add Male beneficiaries I would add it to the Unique beneficiaries query. I would then have to create a uniquebeneficiaries query for each criteria: one for each gender, one for each...

Thanks for the reply, A couple things, I was playing with those quesries the first one works fine, does what it's supposed to. I get a count of beneficiaries for each clientID. The second gives me a "Total beneficiaries not found in expression error". I did maintain those same names for...

Hello all, My problem includes these 3 main tables: Clients, Beneficiaries, Visits 1 client has many beneficiaries but when I log the visit, it’s logged [with a date] PER client not per each beneficiary. Therefore, there is not direct relationship between beneficiaries and visits, it is through...

Well theres no more need to use [2008], it is a yes/no field. I'm trying to replace that with [Date]. I was playing around with something like: Under 5: Abs(Sum(IIf([AGE]<5 And [DATE]=Between [Enter Start Date] and [Enter End Date],True))) And i know this logic is off and it dosen't work, but...

Hello everybody, What i'm trying to accomplish is getting these "count" formulas examples: Under 5: Abs(Sum(IIf([AGE]<5 And [2008]=Yes,True))) 5-9: Abs(Sum(IIf([AGE]>=5 And [AGE]<=9 And [2008]=Yes,True))) Right now they are telling me the counts correctly with the criteria that the data...

Wow, that does work great actually, thanks a lot.

Hello all, I am trying to add command button to open a new form. I want the new form to be locked into the current record only. For example, my main table has "Case Number field", which is an autonumber with a format, and i want to open a new form that adds notes for the case number being...

Thanks a lot for all your help. All of these methods are working, now i just need to speak to the powers that be to see which they prefer and deem as most efficient! Thanks.

Thanks for your reply, so what would be the best way to do this? Is there a calculated field i can use for each threshold? Maybe with a calculation of some sort? Ultimately, i want to be able to open up the query and for it to show me the thresholds at the top, and the counts for how many people...

This might be a bit difficult to explain, but i will give it my best shot. I need queries to give me the count in various fields, but with specific thresholds within the particular field, and with a criteria. So for example, I have an age field calculated. Now i created a new query to give me...