Search results

I am trying to figure out how to set up a formula that would perform a calculation based off of data in 3 separate cells with one or more criteria being met: Cells are "Department Number", "Person's Name", "Field Ticket Total" and "Calculated Field" 1st criteria to be met: Last 3 digits of...

:eek: I have the following formula in a query, and am trying to get it to stop rounding up. I am trying to determine someone's age as of 7/1/08 with this formula Age Band: ((#7/1/2008#-[Date of Birth])/365), but I can't seem to get any formula to work. Example: If someone's age calculates to...

I've got a spreadsheet that has one column for someone's current salary, one for their annual increase, one for the percentage, and one for the resulting "new salary". Current Increase Amt Increase % New Salary EX: 140,000 15,000...

I have the following problem and would appreciate any help anyone could give: I have a report with the following group footer calculation: ="Missing Deduct Total: " & IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K Deduct])) I want to get a grand total on the report...

I have the following issue. Any help would be greatly appreciated. Here's the spreadsheet I've got: EmpID Emp Name DepRelation DepName DepID 81117 Doe, Charles Spouse Doe, Sue 123456789 81117 Doe, Charles Child Doe, Jane 987654321 81117 Doe, Charles...

Newbie here. I think this is a pretty simple issue, but maybe not. I have a database where I am using a combo box to select values from a table. There are other values associated with the value I am choosing in my combo box that I would like to automatically update in the text box once I...