PDA

View Full Version : How to obtain, how many times "XXX" was visited?


normanf
June 1st, 2004, 03:15 AM
Hi there,

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

regards

Norman

John Vinson
June 1st, 2004, 03:39 AM
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

normanf
June 1st, 2004, 05:38 AM
John,
thanks

the table structure:
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
>.
>

Google