Formula to give squense number

[K]

Hi all, I have query with the name "Data" and in this query I have one
column
with the name "Ref" and in that column I have values like see below

Ref………col heading
bbc
bbc
bbc
msn
msn
google
google
google
google

In query design view I need some kind of formula in next column of
"Ref" column that when I run query then I should get result like
see
below

Ref Num………col heading
bbc 1
bbc 1
bbc 1
msn 2
msn 2
gog 3
gog 3
gog 3
gog 3

Basically I am trying to give number to the matching values in "Ref"
column but It should be in a way that first matchin value should have
number 1 and next matching values should have number 1 + 1. Hope I
was able to explain my question. Please can any friend can help