Recent content by hthg21

The problem is the fields i want aren't in the main form, they are in 2 other subforms. I think either an Append query or some code grabbing the records i want and putting them in the third table is needed.

I won't have a pic until tomorrow, but what is happening is that i get the linked data from the main form, but i want a couple pieces of the data from another subform. I just dont want the users to have to enter the Student Name and Topic in twice.

Galaxiom, Thanks for the quick response, but it seems to me the logical progression would be to create in the following order: Class Students Topics Grade Am I missing something, I do have a thick skull?:banghead:

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

I was only seeing one line in the query return, sometimes the most simple problems cause the most headache.

As I sat here and :banghead: I realized that in my query I had the Total in the DateOfFlight set as Group By instead of Where. Thanks pbaldy for your help!

Here it is and I'm up for any and all suggestions. I had to delete a bunch of the Reports & Forms, but this should do.

I need the tblAircraft so I can get the time just for a particular aircraft. In the US, Seattle area.

I attached a pic of the flight table with some test data in it. I was running the query using the following N71KP=AircraftID 3 01/01/14 thru 03/01/14. It should be 22-1.3=4.7 total hobbs & it is returning with 1.7 as the total. Thanks for your help!

HobbStart & HobbsEnding are both Numbers-Decimal.

I posted the wrong pic! I'm all screwed up.

I should have explained that FlightHobbsStart & MaintenanceHobbsStart are fixed times and not used in the calculation I'm trying to do.

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

Thanks Galaxiom! How about if I wanted to display all Hoist Operators even if they haven't been on a flight? How about if I wanted to display which Role they filled?

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