Thanks for sharing - and happy to have you onboard. Cheers

Thanks for the feedback! Ok, good question. The short answer is: don't use multivalued fields if you can avoid it. A much better approach, and one that works well with Reports is to make yourself a separate table. Say you have a table of books that has an Autonumber key (1,2,3 etc) called BookID. One row per book. Also, you have a table of authors also with an Autonumber key called AuthorID. When you want to add the authors to the book, just have a third table that has its own Autonumber key BookAuthorID, the AuthorID, and the BookID as columns. Then you can have all the authors assigned to the right books and vice versa, with no duplication. You can use this approach for anything that you might use a multivalue field for and it will work nicely on reports and other queries. Whenever you want to see everything together, just drag all three tables into the query view then use that query for your Report. Give it a try!

Fair enough - I think many people want to be able to use powerful online visuals like you can find in Power BI. Access does have Modern Charts which are neat and can be used for some great visuals too but they don't compare to Power BI; I'll cover these in a future episode. IMHO where reports shine is in day-to-day operations, printed materials for meetings, etc. Without some styling they definitely look old these days! Thanks for the feedback!

Glad you like them! cheers

Glad you think so!

Thx!

Yes you can - you can add all kinds of graphics to the reports, including photos. You may need to test out different settings on the image control, ie. sunken, flat, border/no border etc. These are all in the properties.

Glad you enjoyed it! For your query, you probably want to make a form, then add a click or double-click event to your field. If you want to open and view in the same manner like your query, choose the datasheet view or continuous forms. It is a form but it looks like your query. Then you can click on a field and have other forms open etc.

That's a pretty neat project! You can certainly do some interop from your database, using the Word libraries in VBA. it would be similar to my video where I opened another database from the current one, then did some things there before closing and resuming: kzfaq.info/get/bejne/ns6ApaV-sbTNdKc.html except, you will reference the Word libraries in order to get that functionality. Good idea for a video!

Just make a query column MyColumn: [Group A] & ", " & [Group B] Then choose ascending for that column. You could also use some other delimiter instead of ", "; maybe " - " or whatever you like.

@@seanmackenziedataengineering Thnx a lot Sir. Regards

@@seanmackenziedataengineering Thnx Sir. But it puts the data from both the column to a new column and separates them with a comma. Not fresh row for the new record. If there is not another row, I cannot sort. Kindly see if there is a solution to this. Regards

@@satyabanukil779 Ahh I see now, I misunderstood. What you need is a Union query: Select ID, Field1 As MyField From tblMyTable Union Select ID, Field2 As MyField From tblMyTable Order By MyField

@@seanmackenziedataengineering @TLDW_Tutorials Thank you Sir. I tried with Union Queries. But it is returning exactly the the field name which I wrote not the data under it. For example, My code is " SELECT Query1.T1TT AS TeamTotal, 'P1' AS TeamId, "TEAM1" AS Team FROM Query1 GROUP BY Query1.T1TT UNION ALL SELECT Query2.T2TT AS TeamTotal, 'P2' AS TeamId,"TEAM2" AS Team FROM Query2 GROUP BY Query2.T2TT" and so on. But when I execute the code the dataset shows just "TEAM1", "TEAM2" and not the data under these column. So I may be wrong with my syntax since it is a text field. If you get time, kindly help. Regards.

You may have your fields in the Detail section, but perhaps those need to be in a group section, with the Detail section collapsed (so you only get one page), or you can create a summary query first then create a report on that (in that case, put the fields in the Detail).

I hear you! Power BI is pretty awesome and I use it all the time. Did you see how it shot out in front of everyone on the Gartner quadrant? MS must be doing something right.

Lead me to somewhere I can hashing passwords in access please 🤭 In audit process they picked on me storing plain text passwords in a table

@@gerfer6261 Some interesting implementations here: stackoverflow.com/questions/125785/password-hash-function-for-excel-vba One accesses .Net libraries through CreateObject which simplifies things. You can start looking there and see what works for you.