Search results

I currently have a form linked to a subform by SSN. If a previously used SSN is entered into the master form, the subform displays the information for that SSN. Of course after a user enters all the other data into the master form, or tries to make an entry into the subform, they are told...

I would like to create a query that includes "Date", "HoursUsed", and a calculated field named "RemainingBalance". The “RemainingBalance” field needs to be computed on a rolling basis and would look something like this: 480 - (Sum(HoursUsed) WHERE Date > (Date - 365 days)) In other words, 480...