How can I change this line to look at a cell value for the search criteria in access
Src = "Select Flow FROM History WHERE [Month] = 40787 " & "and [Segment] = 'combined' " & "and [CO OW Market] = 'Abbotsford' " ' good
I want to take out 40787 and have it in range("G5") and change 40787 in the above code to look at the cell instead. Mabe something like whats below, but its currently not working
Src = "Select Flow FROM History WHERE [Month] = range("G5").value " & "and [Segment] = 'combined' " & "and [CO OW Market] = 'Abbotsford' " ' good
Bookmarks