Query to work out total?

Cobra

Registered User.
Local time
Today, 16:01
Joined
Dec 8, 2008
Messages
20
Hi, I've made a few posts on here about a certain glider database. I have sorted most of the problems through the help of people on this forum. However, I have recently came up with a new conundrum :eek:

When I enter all the information into my table, it records the different flights which take place with the timings, the launch types, the gliders that participated and also who flew in them. One of the last requirements for my client is that they should be able to use a form to search for a glider and then see how many flights it has participated in and also the total flying time. I have used a query to sort all the flights by the glider which I can then link to the form using the criteria as "[Forms]![frmGlider].[txtglider]" this then allows the query to see what the certain criteria is and then sort it accordingly. The part which I am stuck on is how to get a few text boxes to supply the number of flights which the glider has flown and also to add up the total time of all the flights (total time of each flight is also stored in the table). On the good side, all of this information is stored in one singlular table.
 
Ok, I've worked out how to do this using "Totals". However how can I get a text box to look up to this value?

screenpq8.jpg


I know that I would have to have a table entry which looks to this field but I don't know what it would be called or where I could retrieve the value from.
 
Last edited:
Anyone know?
 

Users who are viewing this thread

Back
Top Bottom