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

  • Thread starter Thread starter normanf
  • Start date Start date
N

normanf

Hi there,

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

regards

Norman
 
Hi there,

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

regards

Norman
Click to expand...

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,
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
 
Back
Top