Recent content by Dylan Ross

  1. D

    Multiple Ifs in an excel formula

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

    Stop the Rounding madness!!!!

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

    Stop the Rounding madness!!!!

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

    Dynamic Cells - Can this be done?

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

    Sum of Sums in report

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

    Sum of Sums in report

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

    Counter in a query

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

    Counter in a query

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

    Counter in a query

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

    text box/combo box problem

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

    text box/combo box problem

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

    text box/combo box problem

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

    text box/combo box problem

    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...
Back
Top Bottom