Recent content by hsevigny

  1. H

    Reporting on Equations

    Thank you! I actually tried that while waiting and it worked perfectly! I was not aware of the storing issue, but that makes sense. Thank you for your help! Heather
  2. H

    Reporting on Equations

    Ok... I need help one more time. I am running a report based off of a query, pretty simple. However, on the form that I created, I have two equations that were built in the 'control source' for the field. I'm not sure how to save these fields on my table, so that they will store the data...
  3. H

    Expressions in Forms

    Thank you all very much. It was successful. The clue about excel was very helpful, the formula is very similar. Thanks again! Heather
  4. H

    Expressions in Forms

    Thank you! This is very helpful. Do you happen to know where the best place is to write the expression. I have tried it through expression builder and on the properties tab but there are 5 different lines you can write it on, I'm not sure which one is right. Heather
  5. H

    Expressions in Forms

    Hi! I am trying to build an expression that will subtract one item on a form from another item: Total days out of work - total hours worked per shift. I have entered an expression in the field that I want the data to go to, but it does not calculate. Can anyone help with how I should...
  6. H

    If/Then statements?

    I have built a system for my employer to track individuals that are out on Leave's of Absence to help them asses our needs. I am trying to build a query that will do the following: Pull those that are out within a specific date range (this I know how to do). Also pulls anyone that might have...
Back
Top Bottom