Search results

  1. H

    Automatically updating fields in a SubForm from another SubForm

    I am having trouble figuring out the method to automatically update some fields in SubForm from 2 other SubForms. I have attached 2 pics, the first GradeEntry1 shows what the tblTopic_Class_Grade form looks like after I manually enter everything into it. GradeEntry2 is what the form looks like...
  2. H

    Query for a specific date range & calculation

    I am trying to calculate the total hobbs time (Ending Hobbs - Starting Hobbs = Total Hobbs) based on a user inputed date range. The query that I created (see attachment) doesn't seem to give me what I'm wanting. I thought that this would be as simple as I made it, but I'm obviously missing...
  3. H

    Trouble with SQL Syntax

    I've been working on this for way too long and can't seem to get it through my thick skull on how to get the results I want.:banghead: I have attached 2 pics of screen shots from two different queries I'm having trouble with the one named "Trouble Query". Here is what I'm trying to obtain: A...
  4. H

    On the right track?

    I am in the process of creating a database and I know that the most important part is getting the table structure setup correctly. If anyone has any suggestions for me I would very much appreciate them. In a nutshell here is what I'm doing this for: We are an Air Support Unit that conducts...
  5. H

    Complex for me Report

    I know this is an easy one, but I just don't know the way to do it. Here is what I have and am trying to accomplish: I have a Contacts Table with a list of people, a Flight Table with a list of flights, dates, and passengers (Passengers from the Contacts Table), and a Query that gives me a...
Back
Top Bottom