Counting sites visits within a year

Solved/Closed
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022 - Updated on Nov 28, 2018 at 02:01 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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
Related:

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 6, 2018 at 09:27 AM
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
2
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022
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?
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 7, 2018 at 11:07 AM
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.
1
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022
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
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 13, 2018 at 03:28 PM
Christos, Good evening.

Glad to have helped you.

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