Problems with Report of Windows OS "Flavors"

[pfrench1]

I have a rather extensive inventory report that works well save for determining the flavor of the Windows OS. For example; my report will display Windows 7 Professional/Enterprise or Vista Business just fine. However, for Windows XP, the only result is "Microsoft Windows XP" nothing whether or not the version is professional or any other variety of XP. I have attached a copy of the query.

[pfrench1]

Thank you, that did the trick for me.

[Hemoco · Accepted solution]

You need to include tblOperatingsystem.Caption in your report. Web40OSName.OSname does not contain the full OS name.