Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can Access calculate similar to Excel's offset/match functions?
I thank you for your reply. The 90><100 stuff hasn't been returning the numbers I need, because I need it to choose the set of numbers where 90 would fall in between. Otherwise, both 92.8 and 97.2 would be returned and what I need is the 85.0 and 92.8 to be returned as well as the correlated...- nikilee
- Post #3
- Forum: Microsoft: Access Other topics
-
Can Access calculate similar to Excel's offset/match functions?
I am trying to take an Excel worksheet and move it into Access because the number of workbooks grow by at least five every day. Here's my problem: I have anywhere from 5 to 15 (depending on the product) fields of numerical data. They are calculations from other parts of the query/table and I...- nikilee
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
