Search results

**SOLVED**Calculated field in query not showing up in report **SOLVED** I have a query which has 14 calculated fields. I've found that, at least by default and the ways I've tried so far, that the only calculated fields in that query which will display are the ones which are in the last of...

Okay, so I have included the project in a download link because it's far easier to show someone what I am talking about rather than tell them. In short, I have an aircraft flight log that incrementally logs each aircraft flight hour and flight cycle. This is summed using the aggregate Sum() in a...

I am designing a way in Access to track parts that have been added to a specific aircraft. Parts have a consumption in Hours, Days, and Cycles. Parts have a lifespan in Hours, Days and Cycles. One table I have is: [NNumber] (an associated foreign key in the Aircraft_Table) , [PartID]...

Okay, I am using this syntax as the control source for an unbound textbox which is supposed to display the calculated unbound textbox in the footer of a sub-form: =Sum([ACTimeInitial]+[txtHourSum]) and =Sum([ACCyclesInitial]+[txtCycleSum]) txtCycleSum and txtHourSum are the names of the...

I don't know what I am doing. (I read the forum topic guidelines!) Basically, I need to associate a specific 'part' with an aircraft that is in the 'Aircraft_Table'. This 'part' can have three variables associated with it upon being added to the aircraft. They are: 'Time in Hours already on the...

Hello, I made a form which is called 'Flight_Log_Update'. The objective here is to be able to input new flight data to update the associated aircraft records. Is it possible to be able to have some sort of input field in the form that allows you to type in, for example, '3.9' which would then...