Hope someone can point me in the right direction.
I have a search that pulls a count by 'UserID' of the number of times that they have accessed available Menus in a month. UserIDs (~30k)are in rows and Menu names are in the Columns (~40)
This is great apart from, not all Users access all the Menus each month, so the results vary in the number of Columns returned. (so currently Appending in an Access Database)
Is there a way to always return 'all' Columns and insert a '0' for each UserID?
Many thanks for any help.
... View more