I'm haveing a tough time converting a query I created into a recordset.
Here is my vba code:
Public Function PriceLookup(PackagingPK As Integer, HarvestDate As Date) As Integer
Dim dbs As Database
Dim rsSQL As DAO.Recordset
Dim strSQL As String
Set dbs = CurrentDb
strSQL = "SELECT...