littlespoon
Registered User.
- Local time
- Yesterday, 19:52
- Joined
- Oct 7, 2015
- Messages
- 18
Hi,
I hope you guys can help me with this. (I also hope I can explain it clearly!)
So. I have a master database (TABLE 1), and a database that I need to check for accuracy (TABLE 2).
One of the things I need to check is price, but Table 2 uses price tiers, whereby the prices from Table 1 are 'rounded up' to the next value in the price tier list and then converted into the corresponding tier.
I want to write a query that takes the price of each record, compares it to the tier lookup, increases it to the next price in the lookup table if necessary, and then returns the corresponding tier.
For example, if a record is priced at £1.75, I need it to check the tier lookup, see that the next tier is £1.99, and return the corresponding tier.
So far I have been able to show each record's price tier from Table 2, pull the price that that corresponds to, and subtract that from the Table 1 price. Where do I go from here? I think I should use DLookup, or DMin, but I don't understand how those functions work.
Thank you!
I hope you guys can help me with this. (I also hope I can explain it clearly!)
So. I have a master database (TABLE 1), and a database that I need to check for accuracy (TABLE 2).
One of the things I need to check is price, but Table 2 uses price tiers, whereby the prices from Table 1 are 'rounded up' to the next value in the price tier list and then converted into the corresponding tier.
I want to write a query that takes the price of each record, compares it to the tier lookup, increases it to the next price in the lookup table if necessary, and then returns the corresponding tier.
For example, if a record is priced at £1.75, I need it to check the tier lookup, see that the next tier is £1.99, and return the corresponding tier.
So far I have been able to show each record's price tier from Table 2, pull the price that that corresponds to, and subtract that from the Table 1 price. Where do I go from here? I think I should use DLookup, or DMin, but I don't understand how those functions work.
Thank you!