Find Jobs
Hire Freelancers

Remove records and create count query

$30-250 USD

Zaprt
Objavljeno pred skoraj 6 leti

$30-250 USD

Plačilo ob dostavi
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.
ID projekta: 17165237

Več o projektu

43 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
43 freelancerjev je oddalo ponudbo s povprečno vrednostjo $133 USD za to delo
Avatar uporabnika
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.
$155 USD v 3 dneh
5,0 (251 ocen)
7,8
7,8
Avatar uporabnika
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 worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD v 3 dneh
4,9 (364 ocen)
8,0
8,0
Avatar uporabnika
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 gives me the strength and necessary boost to keep on trying to keep my clients satisfied. A small part of my work quality and professionalism can be retrieved in my portfolio which you're kindly requested to visit. I read in your brief that you require some formatting of Excel data and especially removing some records meeting specific criteria among other small tasks. All of them are among tasks that I have completed in the past and know exactly what to do to integrate them into your Excel file. I will write the necessary code in the Excel file to prepare the data before importing into the Access database. I'd like to talk with you before proceeding. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$150 USD v 7 dneh
4,9 (285 ocen)
7,6
7,6
Avatar uporabnika
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.
$150 USD v 3 dneh
4,9 (339 ocen)
7,4
7,4
Avatar uporabnika
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
$150 USD v 3 dneh
4,9 (239 ocen)
6,9
6,9
Avatar uporabnika
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 time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$50 USD v 1 dnevu
4,9 (179 ocen)
6,7
6,7
Avatar uporabnika
Respected Sir, Do u want that query or you just need the final resultset imported in access? Regards Pankaj Garg
$277 USD v 3 dneh
4,9 (52 ocen)
6,6
6,6
Avatar uporabnika
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 include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
$277 USD v 10 dneh
4,8 (44 ocen)
6,6
6,6
Avatar uporabnika
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 modern design. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
$130 USD v 2 dneh
5,0 (125 ocen)
6,6
6,6
Avatar uporabnika
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
$50 USD v 1 dnevu
5,0 (154 ocen)
6,4
6,4
Avatar uporabnika
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 information.
$98 USD v 2 dneh
5,0 (146 ocen)
5,9
5,9
Avatar uporabnika
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 this opportunity to work on your project. Thanks, Peter
$155 USD v 3 dneh
5,0 (86 ocen)
6,0
6,0
Avatar uporabnika
I am proficient with excel macro/VBA , I can write the macro to clean up the data as specified, I am available to start your project right away, and the work can be delivered within 24 hours, feel free to message me if you are interested, looking forward to hear from you and work on your project.
$100 USD v 1 dnevu
5,0 (100 ocen)
6,2
6,2
Avatar uporabnika
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
$111 USD v 3 dneh
5,0 (61 ocen)
5,8
5,8
Avatar uporabnika
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 1979. I'm developing with Access/SQL/VB/Excel since 1997. I can write for you a user-friendly program using MS Access . I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura
$155 USD v 3 dneh
4,7 (57 ocen)
6,2
6,2
Avatar uporabnika
Hi, I am interested in this project. I have considerable expertise in the design and creation of MS Access databases. I would be happy to discuss about your specific requirements. Regards
$100 USD v 3 dneh
5,0 (8 ocen)
4,2
4,2
Avatar uporabnika
With 12 years professional experience i can do following job without any shortcoming: 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.
$30 USD v 1 dnevu
5,0 (18 ocen)
4,0
4,0
Avatar uporabnika
I have 10+years of experience in Advance Excel, VBA, Macros, MS access and other office integration development. I am sure i can handle your request
$111 USD v 3 dneh
5,0 (11 ocen)
4,2
4,2
Avatar uporabnika
Hello, I reviewed your file and I can do all three things you need. The two reports and the removal of the unnecessary data per your request. Let's chat to discuss more details. I am available to start working right now. Thank you.
$70 USD v 1 dnevu
5,0 (7 ocen)
3,7
3,7
Avatar uporabnika
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas , formatting, etc. thanks
$150 USD v 4 dneh
4,9 (24 ocen)
4,0
4,0

O stranki

Zastava UNITED STATES
United States
0,0
0
Član(ica) od jun. 13, 2018

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.