Querry question.

[ZJGMoparman]

I am trying to create a database to keep track of my RC Plane flying and battery charges. I have the following tables: Batteries, Charges, Flights. What I am trying to do is create a query that will only show the batteries that have not been charged. The way I planned to do this is by creating a criteria that only shows values if the total number of flights for that battery - the total number of charges for that battery is > 0. Is this possible? And if so, how would I go about doing this? Are there better methods? I'm new to access so all help is greatly appreciated.

[ZJGMoparman]

I was also thinking that a better method to display only the batteries that are not charged would be to display all batteries that the most recent "flightdate" field is sooner than the most recent "chargedate" field.

The way I have the tables set up... I have a flight table that has information about the specific flight (airplane, battery used, flight time ) and then I have a flight session table that has a date field. Mulitple flights can be linked to one session. The session table includes more generic information such as flight date, weather, location, temperature... there is then a third table that is used for battery charges. It includes fields such as charge date, charge time, restored capacity ect...

Is it possible to get a combo box or list box that will display all of the batteries that the most recent session date is sooner than the most recent charge date for that battery?

Also, is there any way to link the flight time for that specific battery to the restored capacity when it is charged?

[orange]

Since you are new to Access, I recommend you do a little reading on database concepts and design.
Here is a good, short article on design principles. It also include links to Normalization which is key to good design.
http://forums.aspfree.com/attachment...2&d=1201055452

This is a link to a procedure for designing and creating a database.
http://www.rogersaccesslibrary.com/T...lationship.zip

There are a number of existing data models on a variety of subjects at
http://www.databaseanswers.org

Good luck.