Counting Sites visits within a year [Solved]

christossol 11 Posts Friday February 17, 2017Registration date February 22, 2018 Last seen - Feb 6, 2018 at 08:05 AM - Latest reply: Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen
- Feb 13, 2018 at 03:28 PM
Hi All,

I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below:
Site Site Report Date Year Visit Reason
ID Name ID
3 MO 39 17/03/2015 2015 Gen Maint.
3 MO 40 02/04/2015 2015 Fault FM
3 MO 41 02/04/2015 2015 Fault DVBT
3 MO 42 02/04/2016 2016 Gen Maint.
3 MO 43 02/04/2017 2017 Fault FM
3 MO 44 02/04/2018 2018 Fault FM
5 VAV 51 02/04/2015 2015 Gen Maint.
5 VAV 52 03/04/2016 2016 Gen Maint.
5 VAV 53 08/04/2017 2017 Gen Maint.
32 MAD 64 21/04/2015 2015 Fault FM
32 MAD 65 22/05/2016 2016 Fault DVBT
32 MAD 66 22/06/2017 2017 Fault FM

The database is about 2500 rows and it keeps updated. There are 82 sites each site has its site id. For each visit a service report is issued and entered in the table with the date visit and the visit reason. All i need is to have on a separate sheet reading this info and by entering the year to produce me a table with the number of visit per site within that year.

Thank you all

Christos
See more 

Your reply

5 replies

Best answer
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 6, 2018 at 09:27 AM
1
Thank you
christossol, Good afternoon.

I won't put the formulas here and explain how to assemble the layout because it will get too big text to explain.
I hope you understand.

I did an example for you using your sample.

https://www.sendspace.com/file/ehzmuj

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão

Thank you Mazzaropi 1

has helped 2146 users this month

christossol 11 Posts Friday February 17, 2017Registration date February 22, 2018 Last seen - Feb 7, 2018 at 02:06 AM
Hi Marcilio,
Thank you for your response but I can't download throu sendspace does not allow me with the free account....can u send via email please or a dropbox link?
Respond to Mazzaropi
Best answer
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 7, 2018 at 11:07 AM
1
Thank you
christossol, Good afternoon.

To use www.sendspace.com is simple, without registration and totally free.

a) Click a blue link at my message.

b) When window opened, click a blue retangle written DOWNLOAD

c) When gray box opened click OK and file is saved at your computer.
Only this.

".....can u send via email please ..."
Sorry, it's against the forum rules.

I hope it helps.

Thank you Mazzaropi 1

has helped 2146 users this month

christossol 11 Posts Friday February 17, 2017Registration date February 22, 2018 Last seen - Feb 13, 2018 at 02:11 PM
Dear Marcilio Good afternoon,

U were right it was downloading and I did not see it....
Your solution worked perfectly. Thank you very much and I appreciate the effort.
Christos
Respond to Mazzaropi
Best answer
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 13, 2018 at 03:28 PM
1
Thank you
Christos, Good evening.

Glad to have helped you.

Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão

Thank you Mazzaropi 1

has helped 2146 users this month

Respond to Mazzaropi