Hi all,
It's nice to see that there is an active forum for people who need help with Access
I would like to seek the expertise and opinion of the fellow users here on how I can use Access to build a full dataset in a single table based on skeletal/basic data points? Here is a picture to explain what I mean:
So basically, the table on the left is the one with basic data points in the various columns. The one on the right is the final result after the values in the various columns are duplicated for each possible combination for all the columns. I understand that this can be done easily in Excel but albeit, manually. I would like to know if this can be accomplished in access as I experience the need to change the basic data points constantly, making it troublesome to do in Excel.
Many thanks in advance
HiddenStar