I have a query in Access. There will be a maximum of 5 rows.
In criteria/field I would like to select the number from row1, in another criteria the number from row2, in another criteria/field the number from row3, in another criteria/field the number from row4, in another criteria/field the number from row5.
In other words there has to be a way to go to design view in a criteria, select my field and under criteria select a record in a designated row under a specific field.
IDNumber(Criteria) select the record in row 3. In this case that would be 233.