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