C
Cy
I hope someone might be able to offer some assistance. I posted a
similar post, but the solution provided didn't work.
Here here goes.
We have crews that go out to visit clients. Might be 2 to a 5 person
crew. They will visit a location to perform a task. If the task is
not completed on the day they visit, they will visit again the next
day.
What we'd like to be able to do is count the number of visits we make
to a client within a year. In the scenario I gave above, that would
be counted as one visit.
We enter all our information into a payroll screen that has the
following fields. ContractNo for contract number, a jobcode used to
identify what we did while there, svcdate the date of service.
Below is the original post I made a few days ago, with a different way
of describing what I just said.
Any help is appreciated.
Thanks.
Morning all,
I have field that contains dates. I need to add up each time a visit
is made. Easy enough. In a query, I run the date count and all works
great. However, I need to filter out if the date of the last visit
and next visit are within 2 days of themselves. Example. They might
visit a customer on the November 21. They didn't complete the work.
They will not return on the 22nd, because it's a Holiday, so they will
return on the 23rd to finish up. I need to count that span of time as
1 visit, not 2.
Any thoughts, suggestions?
Thanks
similar post, but the solution provided didn't work.
Here here goes.
We have crews that go out to visit clients. Might be 2 to a 5 person
crew. They will visit a location to perform a task. If the task is
not completed on the day they visit, they will visit again the next
day.
What we'd like to be able to do is count the number of visits we make
to a client within a year. In the scenario I gave above, that would
be counted as one visit.
We enter all our information into a payroll screen that has the
following fields. ContractNo for contract number, a jobcode used to
identify what we did while there, svcdate the date of service.
Below is the original post I made a few days ago, with a different way
of describing what I just said.
Any help is appreciated.
Thanks.
Morning all,
I have field that contains dates. I need to add up each time a visit
is made. Easy enough. In a query, I run the date count and all works
great. However, I need to filter out if the date of the last visit
and next visit are within 2 days of themselves. Example. They might
visit a customer on the November 21. They didn't complete the work.
They will not return on the 22nd, because it's a Holiday, so they will
return on the 23rd to finish up. I need to count that span of time as
1 visit, not 2.
Any thoughts, suggestions?
Thanks