Search results

  1. A

    Total values in report footer

    Used a cross tab query in a subreport. All is well...thank you all!
  2. A

    Total values in report footer

    And try the total query in a subreport.
  3. A

    Total values in report footer

    Will give dcount a try tomorrow
  4. A

    Total values in report footer

    Is there a way to iterate through each model type to obtain sums for each without having to write a sum formula for each aircraft type?
  5. A

    Total values in report footer

    Got it...ditched the combo. Combined two different tables in query. All is good now in calculations. Didnt think about...your comment/question did the trick...thank you from across the ocean. Hope all in your family is doing ok during COVID. dave
  6. A

    Total values in report footer

    Yes....because it allows me to do this to select the aircraft model =[combo45ACNumber].[column](1) The model number is not part of the query (for now...can I populate the AC model in the query?.
  7. A

    Total values in report footer

    My report footer is not recognizing the values in a text box that I populate from a combobox using the [field].column(1) formula. I get a text result in the text box but I wish to sum, or count, by how many times a particular value comes up. The value is not stored in a field but displays in...
  8. A

    Table Analysis - am I on the right track with these relationships

    I still have the schema from post 16. I had to leave the work for a bit...now back...here is a second attempt I did. I still have all of your original suggestions. Still trying to educate myself on setting up relationships. Inspectors will inspect each building daily on each of 3 shifts...
  9. A

    Table Analysis - am I on the right track with these relationships

    Last comment prior to hitting the hay...queries I develop use this schema result in an inability to update anything in the query or the form. What am I missing? Are my relationship joins not correct? Doing it right sure is a lot more challenging than doing it wrong :) However, I do want to...
  10. A

    Table Analysis - am I on the right track with these relationships

    Is this what you are referring too for compound index? ....will look for answer tomorrow if you're posting... If not...Have a great weekend.
  11. A

    Table Analysis - am I on the right track with these relationships

    I know it might be very late where you are - I do appreciate your help. Learning curve can be tough...and just when I thought I was getting a grasp on this :)
  12. A

    Table Analysis - am I on the right track with these relationships

    InspectionID_FK and ItemID_FK as compound index to prevent duplicate pairs Set those two fields as Index: Yes, (No Duplicates)? Removed Primary Key on tblInspectionDetails - should it remain an autonumber field or just a number field?
  13. A

    Table Analysis - am I on the right track with these relationships

    I see you point on the Not Inspected issue.
  14. A

    Table Analysis - am I on the right track with these relationships

    Understand...I was hoping working hard on the relationships and figuring out the necessary fields would help me visualize the real world stuff. Willing to go back and look at that line of thinking again. I envision just having checkboxes on a single form once they get to that page. Checking...
  15. A

    Table Analysis - am I on the right track with these relationships

    So for this airport, Terminal A and Location areas associated with that building. Empty cells are not a problem. By selecting the building they will be presented with a cascaded combobox of locations inside of and associated only with that building. But the checkboxes can show for all...
  16. A

    Table Analysis - am I on the right track with these relationships

    back in office....will try your suggestions.
  17. A

    Table Analysis - am I on the right track with these relationships

    Yes...but some locations it may not make sense to inspect all 37 items. But to have the checkbox listed on the inspection form is O.K. they simply select what applies. Later I may trymy hand at cascading combo boxes...plenty on the web on that I think. For now, simple is good.
  18. A

    Table Analysis - am I on the right track with these relationships

    I have to leave for about 2 hours to do some other airfield work. My sincere appreciation for your skills, knowledge, and assistance. I will check back when I get back to the office.
  19. A

    Table Analysis - am I on the right track with these relationships

    personnel should select what building they are inspecting and the location inside that building to start the inspection. Then select by check box what is Satisfactory (no comments) or Unsatisfactory( with comments). I just wasn't sure where to put that in the relationship tree or quite how to...
Top Bottom