Recent content by bejammin

I have a form with several other forms embedded in it. In one of the particular sub-forms i wanted to have one text box where you type in a number and another textbox that displays an automatic description corresponding to this number. The sub form works fine on it's own - i set a condition...

I'm not entirely sure I understand - I can't use a table to put the information in directly. I'm writing a database that diplays and prints reports that display the maintenance licences for the helicopter pilots at my base. The secretary uses a form to update pilot information. ID No is a stamp...

Is there any way i can calculate a rolling average for a field in a record, based on the 10 previous records? Cheers, Ben

In my query, i want to automatically display the value of another field from the previous record in a field in my current record. i.e. Name Value Previous Record 1 1 Record 2 2 1 Record 3 7 2 Record 4 1 7 Is it...

I have a table that has fields: ID NO (Autonumber), A(checkbox), B(checkbox) and C(checkbox), with many hundreds of records. I have a report based on a query for this table, that selects a particular record based on the user entering the desired ID NO. In my VB code for this report, i want to...