Is this some kind of homework assignment?
For there to be any "next" row, there has to be some order to the rows. ...
and that "ID" field is something of a mystery to me. Usually, an "ID" field
is a unique identifier for the row. In your example, you have multiple rows
with the same ID.
If you were explaining this to a person, rather than a computer, how would
you explain how to tell which row is "next"?
Now make it even simpler, because the computer is simpler than any person
you'd explain it to!
More info, please!
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
I'm not sure I'm understanding how you'd "divide two rows".
In Access, a row (in a table) can contain many fields. Why would you be
needing to divide them? What will dividing them allow you to do?
I'm trying to understand the underlying business need to see if there
might
be another way to use Access.
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
Here's what I am trying to do. I have the width and height of shipping
boxes and their rates. However, this db has errors in it. Some of the
prices have been typed as 3 digits instead of 2. My job is to locate
those errors in a db with over 50,000 records.
ID Width Height Price
001 24 26 35
001 24 27 36
001 24 30 38
002 26 26 45
002 26 27 54
........
How would I do that in access. I am supposed to divide the (price next
row)/ price prev). If it is >3 then there is an error then report it.
This was the only hint I was given.
RB
