Re: This one's a challenge: 1.9 not equaling 1.9..... What's going on???
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Wed, 28 Jun 2006 23:11:06 -0500
pwizzle@xxxxxxxxx wrote:
I've got a real challenge this time with an access database that I'm[snip]
writing. I'm at my witts end trying to figure out a feasible solution,
but to no avail. I'm writing this database for work, and failing to
come up with a fix for this problem is going to be a major problem.
Long story short:
1) I work for a grocery store, and I have imported a listing of about
12,000 items that we sell into this database. This list includes
dimensional data about every product (height, width, and depth)
2) We have several people out in our stores measuring product in an
effort to audit this data. They input their measurements into a form
that I put together and the form dumps the audit measurements into
separate columns in the same table via a recordset.
3) I have conditional formatting set up that compares the data in the
table to the data they enter into the text boxes. This conditional
formatting works fine and correctly identifies when the two numbers do
not equal by coloring the text box red.
My problem is that I have a query put together that spits out all of
the data in the table. For example, column #1 in the query is titled
"System Case Height" and column #2 is titled "Audited Case Height".
Column #3 is set up to spit out "Yes" or "No" depending on if these
numbers are equal or not.
Here is the code for column 3:
CaseHeight_In_Tollerance?:
IIf([System_Case_Height]-[Audit_Case_Height]=0),"Yes","No")
The standard way of dealing with precision anomalies is to
do the comparison something like this:
IIf(Abs([System_Case_Height] - [Audit_Case_Height]) <
..000001, "Yes","No")
--
Marsh
MVP [MS Access]
.
- References:
- Prev by Date: Re: Update Query
- Next by Date: Re: how do i calculate an age using MS Access? I'm a novice.
- Previous by thread: RE: This one's a challenge: 1.9 not equaling 1.9..... What's going on?
- Next by thread: Re: Auto calculate sum of multiple fields by record
- Index(es):
Relevant Pages
|
