MS Access Code to Place SQL Values Into Report - 26/10/2011

MS Access reports are quite useful and powerful, but there are times where you may wish to set a certain field (field 4 in this case) with the results of a database query (in this case field1 and field2). This is mostly for my notes and my memory!