How to Add a Row Number to your Query in Microsoft Access

[@shamwailmalik716]

excellent one... thanks

[@seanmackenziedataengineering]

Glad you liked it!

[@ozairkhalid]

Thank you very much Sean - another wonderful video.

[@seanmackenziedataengineering]

Thanks!

[@peterhamer504]

Thanks Sean. That sort of query comes up every now and then. And Monaco is very good 👍

[@seanmackenziedataengineering]

I'm happy that the SQL editor is being replaced/augmented. Long overdue and this seems to the job nicely!

[@HomeEngineer-wm5fg]

Appreciate this. Thanks!

[@seanmackenziedataengineering]

My pleasure! Glad it helped.

[@HomeEngineer-wm5fg]

Any word when they are going to extend the Monaco Editor for VBA?

[@seanmackenziedataengineering]

That's a good question. I don't know the answer to that one. If any viewers know this, please comment!

[@rousebithol7519]

Thank u Sean, but how could I get beautiful sql view be like yours in videos?

[@seanmackenziedataengineering]

It is available in the Microsoft 365 update for Microsoft Office. It should update you to Version 2410 or higher (check File > Account > About Access). Then you should see the editor when you design a query and go to SQL view. If you don't see it, you can go File > Options > Current Database > Enable Monaco SQL Editor Enjoy!

[@larabyacine3397]

Good morning But how did the sql editor appear to you like that?

[@seanmackenziedataengineering]

You just need to install the latest version of Office 365 to get the new editor. I talk about the new editor and version at 0:49 in the video (you can see the minimum version that get the editor). Pretty nice addition, isn't it?

[@tuffley2175]

Editor is something new for me 🔧🧜🏻‍♀️🧜🏻alias

[@seanmackenziedataengineering]

It is a new feature in Access! You need to update to the current version (2410) to get the editor (if you didn't already)

[@alexandrucoman1082]

I have MS Office 2021 how can I get the new SQL Editor in Access?

[@seanmackenziedataengineering]

As far as I know, it is only available in Office 365, in the "Current Version" release. If you're stuck on 2021 or earlier and still need a good editor, I would recommend the free Notepad++ which you can see I use in other videos for simple editing. Just set the language to SQL and it will do all the highlighting for you.

[@alexandrucoman1082]

@seanmackenziedataengineering thank you!! I appreciate it🙏

[@satyabanukil779]

In which version MS Office it is available

[@seanmackenziedataengineering]

In the video at 0:58

[@satyabanukil779]

@@seanmackenziedataengineering Thank you Sir. Looking forward for your advice on another post where you wanted to know my requirements on building a SUM function. Regards.