Find Jobs
Hire Freelancers

Remove records and create count query

$30-250 USD

Closed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
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

About the project

43 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
43 freelancers are bidding on average $133 USD for this job
User 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 in 3 days
5.0 (251 reviews)
7.8
7.8
User 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 in 3 days
4.9 (364 reviews)
8.0
8.0
User 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 in 7 days
4.9 (285 reviews)
7.6
7.6
User 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 in 3 days
4.9 (339 reviews)
7.4
7.4
User 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 in 3 days
4.9 (239 reviews)
6.9
6.9
User 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 in 1 day
4.9 (179 reviews)
6.7
6.7
User Avatar
Respected Sir, Do u want that query or you just need the final resultset imported in access? Regards Pankaj Garg
$277 USD in 3 days
4.9 (52 reviews)
6.6
6.6
User 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 in 10 days
4.8 (44 reviews)
6.6
6.6
User 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 in 2 days
5.0 (125 reviews)
6.6
6.6
User 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 in 1 day
5.0 (154 reviews)
6.4
6.4
User 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 in 2 days
5.0 (146 reviews)
5.9
5.9
User 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 in 3 days
5.0 (86 reviews)
6.0
6.0
User 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 in 1 day
5.0 (100 reviews)
6.2
6.2
User 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 in 3 days
5.0 (61 reviews)
5.8
5.8
User 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 in 3 days
4.7 (57 reviews)
6.2
6.2
User 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 in 3 days
5.0 (8 reviews)
4.2
4.2
User 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 in 1 day
5.0 (18 reviews)
4.0
4.0
User 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 in 3 days
5.0 (11 reviews)
4.2
4.2
User 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 in 1 day
5.0 (7 reviews)
3.7
3.7
User 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 in 4 days
4.9 (24 reviews)
4.0
4.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jun 13, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.