I have created a select query based on my Table1. The query grabs all records where the field Similar is not blank. (this field has various codes stored in it).
What i want to do is match up the various codes (e.g. all the ones are grouped, the two's are grouped, etc.) and then compare whether or not the price is identical in the Price field (for a set of records with the same code). If it is, then the Revised Price should be identical. However, if the Price is not identical, then the revised price would be different but the Percent Revised should be identical.
Does this make sense? Can i do the comparisons in a query or do i need to go to a form and create some calculated mess there?
Then afterwards, i need to perform operations on those records. Should i just set up a temp table to throw in all records with the a Similar code of 1 (then compare and do calculations) then move that info back to the regular table, and then grab all records with the Similar code 2 etc...
roddy
What i want to do is match up the various codes (e.g. all the ones are grouped, the two's are grouped, etc.) and then compare whether or not the price is identical in the Price field (for a set of records with the same code). If it is, then the Revised Price should be identical. However, if the Price is not identical, then the revised price would be different but the Percent Revised should be identical.
Does this make sense? Can i do the comparisons in a query or do i need to go to a form and create some calculated mess there?
Then afterwards, i need to perform operations on those records. Should i just set up a temp table to throw in all records with the a Similar code of 1 (then compare and do calculations) then move that info back to the regular table, and then grab all records with the Similar code 2 etc...
roddy