Recent content by waffle

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.

Thanks worked Great!

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

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

Keith, thank you thank you thank you.... that was such an easy fix!

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!

The reason I'm using formulas rather than calculating it by hand is that we often change the variables and are trying to get away from recalculation each time. Saves errors and headaches. Also, we then have to use the results to compute new data that will be displayed in a report for comparison.

They are linked through a third table. Both of these tables call to a table called Jobs that stores all of our previous jobs in a primary key.

OK, I have another question about this. I have two tables and I need to divide one field by another field on a different table. I was using %Change: [Input Table: labor]/[Job associated table:labor]-1 what is incorrect about this?

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.

I also am trying to take the year from the job and turn it into a number in that field so that we can just sort by a year rather than a date. I haven't even begun to attempt that one yet, its still a pipe dream but one can hope cant he?

Tried running an append query and I keep getting a key violation...

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.