Açık

Remove records and create count query

We have a gate access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of time. I would like to have a way to remove these unwanted records either in Access or in Excel and then import to Access. Within same username any record within ten seconds of the previous date and time would be removed. With the new recordset then have two reports created that recaps usage for a selected time. One report to show total record count by User and then a second report to show all usage within a date range and a breakpoint on username with totals.

Beceriler: Veri İşleme, Excel, Microsoft Access, Yazılım Mimarisi, Visual Basic

Daha fazlasını gör: having count(*), sql delete having count greater than 1, having clause in delete query, delete query with group by, select where count greater than 1 group by, sql query for finding records where count > 1, sql having count greater than 1, mysql delete group by having count, vtiger remove quick create, mysql optimize count query, php create drop query, joomla remove article page count, create webpage query access database, linux remove records exist file, excel create web query

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #17165237

Bu iş için 47 freelancer ortalamada $131 teklif veriyor

schoudhary1553

Hello, I can help with you in your project Remove records and create count query. I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Software Architecture, Visual Basic. We have work Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(255 Değerlendirme)
9.3
jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(581 Değerlendirme)
8.2
liangjongai

I can work for you. I'm interested in your project. I've an experience of works with ms excel and vba. Ping me any time to discuss about this project.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(206 Değerlendirme)
7.5
Prashantskin

[login to view URL] I have gone through your project requirements. I will develop your application in Microsoft Access It will remove thse unwanted records in Access . Within same username any record within ten seconds of t Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(588 Değerlendirme)
7.3
KulfiSoftwares

I love excel, and have done several projects to clean, merge, remove duplicates, and even summarize spreadsheets. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work. https:/ Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(235 Değerlendirme)
7.3
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please send me a message so that we can discuss more.

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(271 Değerlendirme)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(199 Değerlendirme)
6.8
paris2785

Hi, there. My name's Paris and I'm considered to be among the most experienced and successful Excel and Access developers on this platform. I've completed more than 230 projects during the last 5 years and this give Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(182 Değerlendirme)
6.9
katilinas

Hello, I'm ready to work on "remove records and create count query" project. I have 5 years experience in Visual Basic, Excel, Microsoft Access. 130 USD - proposed project budget, including scalable code and clean mo Daha Fazla

in %bids___i_period_sub_35% gün içinde130%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(117 Değerlendirme)
6.4
best4best

Hi, I am an Excel expert and can remove multiple entries for any user in short span of time and create further reports as described. Regards Soni

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(145 Değerlendirme)
6.4
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(101 Değerlendirme)
6.3
zu02

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'm programmer/mathematician since 197 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
6.2
WebInfoSolutions

Respected Sir, Do u want that query or you just need the final resultset imported in access? Regards Pankaj Garg

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
6.1
workerbee1974

My passion is building Custom Access Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013.  Some of the databases I have built includ Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)
6.2
vlayausa

Hello, I am proficient with Excel and VBA and I would love to make a macro for this project. I have a lot of experience with similar work and can provide both reports that you need. Please contact me for more Daha Fazla

in %bids___i_period_sub_35% gün içinde98%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(135 Değerlendirme)
5.8
NourElDeen

Dear SIr, I'm expert in boss access and excel and ready to help you in removing unwanted records and can share you sample of my work, msg me for details Kind Regards, NourElDeen

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(59 Değerlendirme)
5.8
in %bids___i_period_sub_35% gün içinde138%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)
6.0
royalcalif

I wish to discuss little bit more about the project for appropriate duration and cost as well. Please pm me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% ac Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(88 Değerlendirme)
5.8
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)
4.8
TechnoGuruu

Hi, As you want to filter out data from your excel sheet based on the criteria of time and username, I would like to assist you on this as well as I will provide other solutions also like counting. Please give me th Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
4.2