Creating a Query in Microsoft Access

[@Shadow.Dragon]

Periodically, I like to go back to the basics to refresh my knowledge (MS might have made changes/additions or I may have forgotten a capability)! Thanks for the "refresh", Richard!

[@599CD]

I like releasing these beginner videos once in a while for "the noobz." Can't just focus on developers all the time. Need fresh blood. :)

[@adelivron]

An American teacher without an accent speaks clearly and concisely and shows the extras so you can use what you learn in the way you need it.

[@Defenestrator18]

These videos have been super helpful to getting started. I have a question: I'm trying to manage a database to store donors and their donations. I'm trying to create a query/report that will sort a list of donors based on donation amount tiers. Like if someone has donated between $1-$99 Friends, $100-$249 Supporter etc. So that we can list those donors in a program for example. How best can I do this or is there a video that already covers something like this?

[@599CD]

599cd.com/QQ

[@hands-on-data]

@@Defenestrator18 An SQL statement like that below could do it SELECT Switch( [FieldName] > 100, 'High', [FieldName] > 50, 'Medium', True, 'Low' ) AS Status FROM TableName;

[@neerajkaushik2800]

Sir, one of my friends hold the data approx 10 crors rows and 50 columnsin microsoft access and make the report from power query using power query and microsoft access, how it is possible because it is very large data, please explain, how he is managing this.

[@justainsley4306]

Can you please explain how to do top 5 for example EACH year in a database? Can’t find anything on it anywhere Or for example I have a bunch of dates and I want the top 5 of whatever associated with only specific years

[@alializadeh8195]

Thanks

[@sadikusallieufofana3027]

Thank you very much Sir you saved me from an embarrassment Please like my comment so I get it anytime I want❤❤