Select item from access

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

I tried looking and using but I am not have luck. It seems so simple, I have been trying different things for 2 hours now.

I am getting compile error: Object required and the rng is selected when I try that. Here is what I did:

Dim rng as date
Set rng = Range("G5")
Src = "Select Flow FROM History WHERE [Month] = Rng " & "and [Segment] = 'combined' " & "and [CO OW Market] = 'Abbotsford' " ' good