Recent content by BenC2

OK, so I'm stuck again :) Lets use the CPL, commercial pilots license as the example. I have 3 tables. The first table, 'Flights', records all the flights company wide. Name, date of flight and sequence etc. The 2nd table, listPPL, is simply a list of all students who have passed the PPL...

A smarter man than me you are, my thanks. :)

Gday, thanks for the reply. I understand what you're saying, and it makes sense. The only complication is when you specify to locate entries where dual >= 30 hours. If each flight entry is only 1 hour long, how do you get it to sum the dual column for that student only, and then return just...

Gday, I have a report in access that takes its data from a query. That query in turn has criteria which are passed to it from a form presented to the user. This form takes name, and a start and end date. That is all. What i'd like to do is from excel, open the report at the name specified by...

Hi :) I am assembling an access DB for a flight school. Its quite a basic DB as i'm new to Access, though seasoned with Excel. Some background. At a flight school, you can either fly with an instructor, known as dual, or by yourself, known as solo. Each time you fly, you will learn a...