Recent content by Dylan Ross

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

Gemme-the-husky: Thanks for this awesome little slash trick. I had no idea this would work, but it does exactly what I needed. Thanks to all for your suggestions. I've got them in my toolbox as well now. DR

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

A little more help First of all, thanks for the advice. I'm still a little stumped, though. Here's how my report is set up with the fields in question: Detail section: [Final Missing 401K Deduct] Group Footer: =IIf(Sum([Final Missing 401K Deduct])>12000,12000,Sum([Final Missing 401K...

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

Wayne, Thanks for responding. I am trying to do this through queries so I can do a mail merge off of a table once I'm finished organizing the data. That's the only reason I can't put it in a report. Any other ideas? DR

dcx......what I'm looking for is: 1 81117 Doe, Charles Spouse Doe, Sue 123456789 2 81117 Doe, Charles Child Doe, Jane 987654321 3 81117 Doe, Charles Child Doe, Jenny 147258369 4 81117 Doe, Charles Child Doe, Jamie 963852741 1 80184 Jones, Mark Spouse Jones, Jane 987321654 2 80184 Jones...

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

Thanks a million dcx693! That was the problem. It's doing exactly what I wanted now! DR

I tried your second suggestion and here's what I typed. You are correct. The form I am working in is in form mode. Here's my syntax: =Forms!Job Opening Form!JobCodeCombo.Column(1) Here's the error message I receive: The expression you entered contains invalid syntax. You may have...

Thanks for the info. I understand what you're doing, I only have one issue. For some reason when I type your suggested sytax at the control source, it continues to tell me the syntax is incorrect. It doesn't like the "=" sign. Here's literally what I'm typing in ...

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