report formatting with options/criteria

Hi, is there a way to create a report in MS Access that shows the following photo click here for photo

Yellow will be an input and based off the input it will return data to the blue cells with respect to the headings in column A.

E.g. if we choose code ‘A’ and location ‘Melb’ then it will populate the corresponding data for Headings 1 , 2 & 3.

the data will be stored in the data base so for every ‘code’ and ‘location’ type there is corresponding data for ‘Heading 1’ ‘Heading 2’ etc etc.

Does this make sense?

submitted by /u/whoslookin_
[link] [comments]