info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Dlookup range
2 views
Skip to first unread message
Floyd Forbes
Jan 3, 2022, 4:08:08 PM1/3/22
to
Hello,
Based on Rank trying to find Amount between Start and End.
How do I find this in a query?
Dlookup Table
Rank Start End Amount
10 1000 2000 $500
Based on Rank trying to find Amount between Start and End.
How do I find this in a query?
Dlookup Table
Rank Start End Amount
10 1000 2000 $500
Ron Weiner
Jan 3, 2022, 6:04:45 PM1/3/22
to
Floyd Forbes pretended :
Your question is more than a little ambiguous, but here goes.
Select Amount from [Dlookup Table]
Where Rank = 10
And Amount Between 1000 And 2000
If the above does not give the intended result(s), please try again
with a batter description of your environment.
Rdub
Select Amount from [Dlookup Table]
Where Rank = 10
And Amount Between 1000 And 2000
If the above does not give the intended result(s), please try again
with a batter description of your environment.
Rdub
0 new messages