Search results

  1. W

    Format Access to show 0 like accounting in Excel

    Is there any format that will allow a 0 to show as a - instead. It would be very useful for the situation that has arisen for me.
  2. W

    Creating a function that cannot be greater than .2

    I have a function that I would like to max out at .2 and I don't know how to go about doing that. Currently it is Equip Inf: (([Equipment]*(0.03*(2006-[Letting Date]))+[Equipment])/([Equipment]))-1 and then I multiply (1+[Equip Inf])*[Equipment] to get my inflation. What I want is for Equip...
  3. W

    "Begins With" function

    There is a filter in Excel that is called begins with and I was wondering if there is anyway to use this in a query to remove only certain items, namely our equipment is labeled, AB000 or something similar where each piece of equipment in that category starts with the same two letters and then...
  4. W

    Using query formula information to create another formula in a seperate query

    I have a query that calculates input information into a value that then needs to be compared to another query values and will be used to output a % change in a third query. Is there any way to make this happen? Thank you in advance!
  5. W

    Storing info from a formula in a form to a table

    Hi, I am an Access newbie and I have a form running about 5 seperate formulas and I would like to store the info in the table that it is associated with so that I can use it later in a query to create another formula. Any help would be greatly appreciated.
  6. W

    More than likely an easy remedy

    I have two tables and one has Job Associated Name and the date we began the job, the other table has the job associated name, however it is repeated. I want to have the date show up on the other table so that I can have it appear on a report. The two tables are linked by job associated name.
Back
Top Bottom