Search results

I am trying to run an IIf function as follows: =IIf([MedicalDueDate]>Date(),IIf(([MedicalDueDate]-Date())<15,"P","P"),"O") So this will check to see if the medical is valid. If it is valid, it will show a green P (in wingdings 2 shows a tick). If it is valid, but within 2wks of expiry it...

I have a table with the following info in it: Aircraft ID Aircraft Type Engine Config Airframe Config I'd like to be able to enter the aircraft ID into my form, and the computer then checks to see if that aircraft ID exists. If it finds it does then it will automatically fill in the type and...

This one is probably an easy one to solve, but its driving me insane at the moment. I've got one form: Log Entry. On this form a user enters all details on a flight. When they enter the aircraft registration I would like the system to use the data in that text box to drag all the aircraft...

Tried this, it just comes up with #Name? The form is linked to the table, would I have to unlink it to make it work, which would mean that the other log data would not display either ....

I am trying to display a logbook in a subform. The logbook will have several entries, most of which are stored in the table as 0.0. When displaying the logbook I only want it to display the fields that have a number greater than 0, all other fields I would like to just show a "-". I cannot...

Damn thing still won't work. I run a query to count the number of landings in 90 days in the logbook, this returns the value zero. I then run another query to group all the sub-queries together which I want to output to a text box on a form. Its the result of this query that returns null...

Sorry again, not very clear this one. I'll start again from the beginning. I am running a query on a pilots logbook to count the number of landings in the last 90 days. The query may return 0, in which case I want it to display 0 in a box so the pilot can get off his ar*e and fly some...

I do want it to display the form, just with a null value in!! Sorry!

Hi again. When I am compiling a query to look for a result, if it is null (no results found), it blanks the results form I am trying to display. I have tried running the NZ function on the form, this doesn't seem to work and I am unsure of how to run this in a query? Any ideas...

I'm also new to Access, but the way I've got around this (which if I'm wrong and doing this in the most cumbersome way ever - TELL ME SOMEONE!!! ) is to build a new query and query all the other queries and use "Group By". In the case of what I was doing I was looking at a number of totals in...

Harry & KKilfoil Thanks for the info, that seems to be going in the right way. This was supposed to be an easy project, I seem to find hurdles after hurdles at the moment!! [This message has been edited by Courtman (edited 12-13-2001).]

Final problem for now I think! I am trying to run a query to find all the records for the year-to-date, i.e. from 01/01/2001. I cannot get the query to enter the current year, I want it to look at WHERE Date = CurrentYear for its results. Thanks to all in advance?

Another logbook query. I have two fields, one which shows my medical date, and the other which shows how many months my medical is valid for. I want this to create a result which says when my medical will expire. For example: Medical 21/11/01, valid for 60 months. The validity needs to be...

I am writing a logbook to keep track of flying hours, and I need to countback in a table to find out when a 90-day period which covers three landings will expire. So, if I have three entries as follows: 01/12/01 03/12/01 04/12/01 The 90-day period will cover those three, and the 90-day expiry...