Find Jobs
Hire Freelancers

Remove records and create count query

$30-250 USD

Avslutat
Publicerad nästan sex år sedan

$30-250 USD

Betalning vid leverans
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.
Project ID: 17165237

Om projektet

43 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
43 frilansar lägger i genomsnitt anbud på $133 USD för detta uppdrag
Använd avatar
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 Om 3 dagar
5,0 (251 omdömen)
7,8
7,8
Använd avatar
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 Om 3 dagar
4,9 (364 omdömen)
8,0
8,0
Använd avatar
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 Om 7 dagar
4,9 (285 omdömen)
7,6
7,6
Använd avatar
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 Om 3 dagar
4,9 (339 omdömen)
7,4
7,4
Använd avatar
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 Om 3 dagar
4,9 (239 omdömen)
6,9
6,9
Använd avatar
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 Om 1 dag
4,9 (179 omdömen)
6,7
6,7
Använd avatar
Respected Sir, Do u want that query or you just need the final resultset imported in access? Regards Pankaj Garg
$277 USD Om 3 dagar
4,9 (52 omdömen)
6,6
6,6
Använd avatar
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 Om 10 dagar
4,8 (44 omdömen)
6,6
6,6
Använd avatar
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 Om 2 dagar
5,0 (125 omdömen)
6,6
6,6
Använd avatar
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 Om 1 dag
5,0 (154 omdömen)
6,4
6,4
Använd avatar
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 Om 2 dagar
5,0 (146 omdömen)
5,9
5,9
Använd avatar
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 Om 3 dagar
5,0 (86 omdömen)
6,0
6,0
Använd avatar
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 Om 1 dag
5,0 (100 omdömen)
6,2
6,2
Använd avatar
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 Om 3 dagar
5,0 (61 omdömen)
5,8
5,8
Använd avatar
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 Om 3 dagar
4,7 (57 omdömen)
6,2
6,2
Använd avatar
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 Om 3 dagar
5,0 (8 omdömen)
4,2
4,2
Använd avatar
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 Om 1 dag
5,0 (18 omdömen)
4,0
4,0
Använd avatar
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 Om 3 dagar
5,0 (11 omdömen)
4,2
4,2
Använd avatar
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 Om 1 dag
5,0 (7 omdömen)
3,7
3,7
Använd avatar
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 Om 4 dagar
4,9 (24 omdömen)
4,0
4,0

Om kunden

Flagga för UNITED STATES
United States
0,0
0
Medlem sedan juni 13, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.