Search results

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

Thanks for the suggestions lagbolt. Squawks don't always belong to an aircraft, every once and a while it is just a piece of equipment. I was going to handle crew just like any other passenger, except there is a Yes/No for being a hoist operator or pilot. Since this won't be a huge...

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

I will make the changes and see where I'm at then. Thanks again for your advice.

Thanks for the advice. The Pass1 = Passenger 1 Pass1Role = Passenger 1 particular Role for that particular flight I have a table for each flight, one for all the roles, and another for all the passengers, plus other that aren't related to this particular issue. I'm trying to keep track of...

I should have explained better as to what I have. In the Flight table I have a Pass1, Pass1Roll, Pass2, Pass2Roll, Pass3, Pass3Roll, etc., all the way to Pass10. I have 9 Operators that do a particular roll and I want to keep track of their currency for that roll. They are required to do the...