How to obtain, how many times "XXX" was visited?

Hi there,

How do i accomplish a count of visits by the date "XXX"
was visited using a query?

regards

Norman

On Mon, 31 May 2004 19:15:50 -0700, "normanf"
wrote:

Hi there,

How do i accomplish a count of visits by the date "XXX"
was visited using a query?

regards

Norman

That depends entirely on how your table is structured and what
constitutes a "visit". Care to give us a hand here? We can't see your
database!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John,
thanks

the table structu
DohID = CompanyId,
Datevisited = date the loacation had a visit
department = is the specific location in the company is
anumber the range from 7 to 12

visiting Order = Per DOHID
first visit = datevisted + department = 7
2nd visit = datevisited + department = 7
and though forth

I hope this is a bit clearer.

regards Norman


-----Original Message-----
On Mon, 31 May 2004 19:15:50 -0700, "normanf"
wrote:

Hi there,

How do i accomplish a count of visits by the date "XXX"
was visited using a query?

regards

Norman

That depends entirely on how your table is structured and
what
constitutes a "visit". Care to give us a hand here? We
can't see your
database!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.