ACCESS V.2003
I have some code as:
Dim d As Database
Dim r As Recordset
Dim strFldVal As String
Set d = DBEngine(0)(0)
Set r = d.OpenRecordset("select Max (RR_MONTH) from tbl_Mbr_ANOC_Data")
r.MoveFirst
strFldVal = Format(Nz(r.Fields(0)), "00")
Which give the max value in tbl_Mbr_ANOC_Data in the field RR_MONTH
I would like to reference that value as criteria in a query. Can anyone tell me what the syntax in the query criteria field would be?
Thanks..