Search results

Hiya all I'm trying to write a query which looks back over the past six calendar months - i.e. from today back to 01-Mar-2008. Can anyone recommend the easiest way to do this in a query please? Thanks!

I have a form with a child-form which displays the results of a query. On the main form are three radio buttons which select different queries in the child form. I'd like to use a VB code to change from one query to the next, depending on which radio button is pressed. How would I best do...

I have a report which lists logbook entries. At the bottom of the first page I'd like the report to give the total for the page. The totals for this page then carry forward to the top of page 2, and at the bottom of page 2 get a total for all of page 1 and page 2. Is this possible in Access...

Hi I have a form with a "Clear Form" button on to allow the user to delete the record they are working on without updating the database. A question window pops up asking if they are sure they want to delete the record, if they answer yes the form will clear and re-load without updating the...

Hi all Can someone advise if this is possible and how I would do it please - I'm going round in circles trying to sort this little problem out! I have a form which posts the results of a query. The results of the query are in a subform, and on the main form are three radio buttons which allow...

I have a form with a sub-form embedded in it which displays the results of a query. On the form are 3 radio buttons - Date, Name, Number - which specify how the query is sorted. How can I re-query the sub-form whenever the radio button is changed?

I am trying to get a list box with todays date in as a default. I would like the user to be able to increase or decrease that date, and based on what they have done re-query a number of sub-forms to show results based on the differing dates. Can anyone please advise how to make a listbox (or...

I've posted this on the Forms queries, and duped it here just in case.... I have a form which contains a sub-form with the results of a query. I would like to add an option box which allows the user to re-sort the query by different columns. The options would be: SORT BY: Airfield Name...

I have a form which contains a sub-form with the results of a query. I would like to add an option box which allows the user to re-sort the query by different columns. The options would be: SORT BY: Airfield Name (default) Date of First Visit No. of Visits ...and this would re-sort the...

Hi, I am trying to get a query to do the following. With this data: Date - From - To 01-Jan-02 - Luton - Manchester 01-Jan-02 - Manchester - Luton 02-Jan-02 - Luton - Fenland 03-Jan-02 - Leicester - Luton I want an output that would count the number of times I've visited Luton, Manchester...

Hi I am trying to run a sequence of code that checks the results of a query when a form opens. I've called the sub Single_Validity(). Based on the results of the query the system will change the properties of a text box on the main form. How do I refer to a query in my VB code? I've...

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

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

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

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