Search results

  1. I

    Tricky summation

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

    Queries to Count Data

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

    Help with command button / relationship in forms

    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...
    • Ibero
    • Thread
    • Replies: 2
    • Forum: Forms
  4. I

    Help with query to do counts!

    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...
Back
Top Bottom