Remote Network And System Administration Job In IT And Networking

Microsoft Access (R)

Find more Network And System Administration remote jobs posted recently Worldwide

I have a database that last freelancer could not finish two minor things, so two things are not working correctly.
1. When connections meeting list gets imported via excel de-duplicate logic is not working
a. De-duplicate by not importing/or deleting that data (data that gets imported that is under Relationships in the template), when new record in import has another record with same fields in: __________ Partner, company name and rdb with yes. All three field must exactly match.
b. De-duplicate in same way for ones already in the database.

2. Report named New Connections not working.
a. So report would show when a record that had nothing in the connector field from a Connection meeting and nothing in Rdb field, later because of new imports (or existing records in db), the Company name of the new record (from import or existing) matches the company name of an existing record (two/multiple records having matching company name) that has connector field blank and Rdb field with yes.
b. Same data points as Data tab.
c. You should be able to see both (all) matching records in the report.
About the recuiter
Member since Nov 11, 2022
Rachit Agarwal
from Buenos Aires, Argentina

Candidate shortlisted and hiredHiring open till - Apr 5, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$239.52

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Construction estimating - commercial and mixed use

Value of this freelance estimating contract is anticipated to be from 3K to 20k depending on interest and qualifications. Project is on a 10 acre lot in Burien WA with 5 new 5:2 wood framed podium buildings that comprise 179 units for new apartments....read more

ZOHO set up

I need help setting up ZOHO - no data transfer needed. Just starting fresh. Basically just leads, accounts, sales orders and permissions. Also want some basic sales dashboards.

Database for business management

I want a system where I generate Job orders imported from an excel file

When the job order is generated there will be 2 types of products

Products in stock for resale and products to be manufactured

There needs to be 3 mi...read more

Looking for Amazon Flat File Expert

I am looking for an Amazon Flat File Expert to create a file of 1000+ SKUs for uploading.

Excel spreadsheet with interactive dashboard

Looking for someone to do a quick job:
- Create Excel spreadsheet with pivot table and corresponding charts
- Data fields and sample data will be provided
- Pivot charts are to be located in one sheet to make a dashboard
- There will...read more