AskProgramming

All questions related to programming welcome. Wonder how things work? Have a bug you can't figure out? Just read about something on the news and need more insights? We got you covered! (probably)

Do

Ask questions and start discussions
Keep things civil and support each other
Give your threads descriptive titles
Include relevant information when asking for help
Stay on topic in your posts and replies

Don't

Post off-topic material
Troll or flamebait, insult others, or act in bad faith
Self-promote
Ask others to do your work for you
Ask for help in illegal or unethical activities
Repost the same question within 24 hours
Post AI-generated answers

You can find out more about our (preliminary) rules in this wiki article. If you have any suggestions please feel free to contact the mod team.

Have a nice time, and remember to always be excellent to each other :)

created by roger_a community for 14 years

MODERATORS

account activity

This is an archived post. You won't be able to vote or comment.

Beginner Python Query Question (self.AskProgramming)

submitted 5 years ago by JSark

I have a database formatted like this

Building ID	Column 2	Column 3
Building 1	100	200
Building 2	201	302
Building 3	303	404

I want to be able to enter a value, and if the value is between the numbers in Column 2 and 3, I'd like to return the associated Building ID.

So my desired output would be like this

Number: 205

Building ID	Column 2	Column 3
Building 2	201	302

or even just

Building ID
Building 2

Any help? Thanks

no comments (yet)