Never mind, I was able to generate the proper values using a VBA module attached to a button's OnClick event. Code below:
'Container variables
Dim SQL, temp, p1, p2, p3, p4, p5, p6, p7, p8, c, q As String
Dim rec As Recordset
Set rec = CurrentDb.OpenRecordset("Passenger", dbOpenDynaset)
Set...