How to delete duplicate records in ms access using sql query työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

I NEED A LOGO CLIP DONE JUST LIKE THE OTHER MAJOR PRODUCTION COMPANIES HAVE. WATCH VIDEO BELOW!!!!! USING MY YOUR TV LOGO.. UNDER THE LOGO ADD TEXT ( A HISTORY ENTERTAINMENT COMPANY) I WANT A WHITE BACK GROUND VERY SIMPLE VERY PROFESSIONAL!!!

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

typing jobs.

I need Desi Adult (ameture, reallife, homemade) picture archieves. Those have good collections from FSI,Exbii,Debonairblog and other Blog/foums, please quote your price with how many GB of Pictures you have * Duplicate should be removed * Should not have thumpnails images

I'm looking for an experienced hacker who specializes in database scraping to assist with lead generation. My main aim is to get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Ideal candidates should have previous experience in the field. Proficiency in data mining and scraping is a must, along with an understanding of lead generation strategies. Strong grips and successful track records on obtaining accurate contact details are key to perform this job efficiently.

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

As a client, I'm in need of a few highly skilled red teamers to demonstrate that administrative level access can be gain on hardened targets. Key Requirements: - The primary goal of this project is to discover any potential weaknesses in the security of the network environment and gaps in the cybersecurity infrastructure's configuration. - We need to show the SOC how their security products can be bypassed. Ideal Skills and Experience: - Proven experience in red teaming. - Solid understanding of common security vulnerabilities and how they can be exploited. - Strong problem-solving skills and the ability to think like a cyber attacker. - Proficiency in using various pentesting tools a...

As an individual requiring assistance with a coloring task, I'm looking for a freelancer with proven expertise in both digital and traditional coloring. A proficient colorist is required to add life to my photographs, invoking emotions and enhancing their overall aesthetic. Key requirements: 1. Skilled in both digital and traditional coloring processes 2. Access to appropriate tools or software for digital coloring 3. An eye for detail and color - to reproduce colors accurately in digital and traditional formats 4. The ability to handle digital photos, specifically. 5. Ability to meet agreed deadlines Experience in similar projects will be a huge plus. Looking forward to seeing your amazing work.

...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm...

Seeking a skilled developer to create a personalized billing software that caters to my business needs. This program should be compatible with the Windows operating system. Must-Have Features: - Inventory Management: The software should assist in tracking, restocking, and managing our inventory efficiently. - Customer Management: Maintaining customer details for smoother transitions and personalized customer experiences is crucial. - Sales Reporting: We require comprehensive sales reports to review our business's progress and areas for improvement. Users: The software should easily accommodate 1-5 users at once, with unique access capabilities for each user. Ideal Candidates: I'm seeking professionals with experience designing and developin...

I am in need of an expert who can proficiently implement DMARC, DKIM and SPF records to improve my email deliverability and security level. I'm currently using GoDaddy as my email service provider, hence, hands-on experience with GoDaddy will be crucial for this project. Key Requirements: - In-depth understanding of implementing DMARC, DKIM and SPF records - Expertise in email security - Experience with GoDaddy and Klaviyo - Ability to complete the task ASAP Only bid if you are confident you can meet these criteria. This is a priority for me and should be handled with the utmost professionalism.

I'm in need of an experienced developer or agency to create a custom assessment platform, similar to Coderbyte/ Hackerrank tailored to my specific needs not limited, but similar to . Here's what I'm looking for: 1. AI-Generated Code Assistance** - **Smart Code Suggestions**: Implement AI algorithms that provide real-time code suggestions and auto-completions similar to tools like GitHub Copilot. - **Code Snippets**: AI can suggest commonly used code snippets based on the problem statement and context. - **Problem Solving Hints**: AI can offer hints or guide candidates through difficult problems without giving away the solution. - **Adaptive Learning**: Use AI to adjust the difficulty of questions based on the candidate�...

I will need to go through your flow and also have the appropriate access to troubleshoot the issue

...hydrometer to measure the specific gravity of lead acid batteries. This will serve as a crucial tool to check the health of various batteries in real-time, ensuring they're operating effectively and do not pose a risk of failure due to overcharging or undercharging. Key Features: - The hydrometer should have a standard accuracy of ±0.01. This level of precision is essential to correctly assess the battery health and predict any potential issues. - The data collected from the hydrometer needs to be available through a web interface. This online access will allow me to monitor multiple batteries from a central location, offering more convenience and control. Ideal Skills and Experience: - Experience in designing ...

I'm in search of an experienced architect who can design a master bathroom suite for me. The suite will be 8 ft by 16 ft in size. Here are the specifics: - Features: The bathroom should include a double vanity and a walk-in shower, but no Jacuzzi tub is needed. - Style: The overall design should be in a contemporary style. This includes a modern, minimalist approach, with sleek lines and a clean aesthetic. - Materials: The bathroom will feature quartz countertops. A minimum 60-inch vanity with a double sink A toilet separated from the rest of the suite by a wall and door. A tiled shower with subway tiles for both the walls and floor, possibly with a built-in bench. A walk-in closet/dressing room. Full-size 32-inch doors. If possible, the wal...

I have an Illustrator file that needs some text changes. All the new text content is ready, so the task mainly involves swapping out the existing text with the updated content. Ideal skills and experience for this project: - Proficiency in Adobe Illustrator - Strong attention to detail - Ability to follow instructions accurately Attached is a sample. Required modifications. 1. Change bar code. 2. Tidy up the text. 3. Duplicate the file and update some text. 4. Resend me with the right dimensions.

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

I'm looking to implement a user registration system for a paid tutorial video platform. Here's what I need: Script for user registration for gaining access for paid tutorial video Workflow Register new account / login fields: full name | email | password Once user creates his account, only he will access his account if he is using the same device where he first registered. Users need to register to gain access to a tutorial video. Once the registration is approve by the administrator, user will be able to login to watch video. Administrator will need dashboard for accounts administration: Registered users: Fields: full name | email | password | [Botton to active or disactive accounts. User IP/Geo Loca...

For App Promo Video for Project Access, Kaybe Virtual Assistant.

...would appreciate a talented freelancer to assist in troubleshooting and resolving the problem. Key Details: - The error message I'm encountering is 'invalid HASH_V1 payload length, decryption failed?' - The error seems to be related to not being able to decrypt payloads - Additionally, I'm getting 'No matching CHILD_SA config found for IP/IP. received DELETE for IKE_SA' on the responder side Your Role: - The primary task is to address and rectify the issues causing the tunnel failure - As of now, the problem seems to be primarily on the responder side Ideal Skills for the Job: - Proficient in StrongSwan VPN - Strong troubleshooting skills - Experienced in resolving encryption-related ...

...with websites in various industries to place links to my three websites. I'm willing to reciprocate by placing links to your site on my platforms. The primary objective of this project is to enhance my website's traffic through valuable backlinks. $3.00 for 1 website, $5.00 for 2 websites or $10.00 for 5 websites, Not Negotiable. Key Requirements: - You should have websites from different industries - You should be willing to place links to my 3 websites on your platform - I will reciprocate by placing links to your websites on my platforms - The primary aim is to increase my site's traffic Ideal Skills: - Proficiency in SEO and backlinking strategies - Prior experience in link building...

...convert my existing HTML5 Casino Game to an online Flask Backend. The backend should integrate with a PostgreSQL database. Key Functionalities: - User Registration and Login: Implement a secure user registration and login system that allows players to create accounts and access the game. - Game Settings Management: Develop a platform that can manage the game settings, with a particular focus on the Slot Machine settings. These include Win Occurrence, Free Spin, Balance, and other relevant parameters. - Database Integration: Connect the Flask backend to the PostgreSQL database so that it can store and retrieve the necessary game and user data. Ideal Skills and Experience: - Proficiency in Flask and PostgreSQL. - Previous experience in convertin...

I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.

...fine last night for data analysis purposes. However, after trying to upload the '' file to GitHub, I encountered an error due to the file size being too large for GitHub. I need to get the Python file running again, but with the '' file stored on an external service to work around the file size limitations of GitHub. Key requirements include: - Identifying and resolving the issue causing the Python file not to run - Storing the '' file on an external service and adjusting the Python code to access it from there Ideal Skills and Experience: - Proficiency in Python - Experience with data analysis and handling large datasets - Familiarity with version control, specifically using GitHub - A...

I need a skilled professional to help me with a few tasks: 1. **WordPress Template Installation**: I have the template that I'd like to use, and I need someone to install it for me onto Hostinger. 2. **Email Backup**: My email account is around 1GB-5GB in size. I need it completely backed up. I don't want to lose any of my emails as Hostinger said when I delete my old site all the emails will move too and they have a guide I can send on transferring it over. 3. **Copy Over Website Content**: I have an existing website, and I need someone to copy over some of the content from there to my new WordPress site. Ideal candidates should: - Have experience with WordPress, email backup. - Be proficient in moving content ...

...programmer who can create a bot that will be used for automated trading on Binary.com. Key Functionalities: - The bot will be designed to execute trades based on predefined strategies. This means it should be able to analyze market conditions and place trades automatically as per the set strategy. Ideal Skills and Experience: - Proficient in Python: Since Python is my preferred programming language for this bot, you should have demonstrable experience in programming with Python. - Knowledge of Binary Trading: A good understanding of binary trading platforms and how they operate is a considerable plus. - Experience with Automated Trading: Prior experience in developing bots for automated trading is highly preferred. - Familiarity with : Gi...

I'm looking for a skilled app developer with expertise in both iOS and Android platforms. The primary function of the app is car service booking. It should have a clean, intuitive interface and be secure to ensure user trust. Ideal Skills and Experience: - Expertise in developing apps for both iOS and Android - Experience in developing service booking apps - Knowledge of secure app development - Strong UI/UX skills Features to Include: - Users should be able to book and pay for services - The app should store previous service records for easy rebooking - Should have a system to compare prices from different service providers. Your proposal should include a timeline and cost estimates for the project.

...who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, ...

I've developed a database using MongoDB for dummy user data. I need an expert to review and enhance it in terms of schema design and security. Key Aspects for MongoDB Schema Design Review: - **Naming Conventions**: Ensure the names of collections and fields align with established conventions. - **Data Types**: Verify that the data types are correctly assigned and appropriate for each field. - **Indexing**: Check if indexes are set up and utilized effectively. Security Measures and CIS Benchmark Review: - **Authentication and Access Control**: Validate that the authentication mechanisms and access controls are properly implemented. - **Encryption and Data Protection**: Review the existing encryption measures and data protection strategies. - **Audit...

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

I'm seeking a skilled and innovative freelancer who can develop a ride optimization algorithm platform for Uber, Lyft, IDrive, and Get Transfer drivers in the United States. This platform should give drivers access to the most profitable rides in real-time, ultimately increasing their revenue and efficiency. Key Platform Features: - Ride Optimization Algorithm: The platform must have an algorithm that helps drivers select long and more profitable rides in real-time. - Real-Time Demand Prediction: It should also predict real-time demand to help drivers make informed decisions. - Fare Estimation Tool: The platform should have a feature to choose the longest and pricing ride from the App ride pool, as well as automatically accept the bes...

exactly similar to this f-system

I require an expert script writer who can create a bash script for data processing tasks that involve the creation and deletion of files, specifically CSV files. ...bash script for data processing tasks that involve the creation and deletion of files, specifically CSV files. Details: - The main task will involve managing CSV data. - The bash script should be able to create and delete selected CSV files. - I'm looking for someone skilled in bash scripting, especially with a focus on file handling and data processing. - Previous experience in working with CSV files, data manipulation and command line tools will be required. - We need the script to be concise, efficient and capable of running smoothly without unnecessary delays. Looking forward ...

As a client, I'm in need of a gifted freelancer who will design an AI chatbot that works hand-in-hand with Google Assistant. This chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who...

I am in need of a skilled Machine Learning Developer who can help me build a causal model. I have a specific dataset that I would like to use for building the model. This dataset is of moderate complexity, featuring multiple variables. The primary goal of the model will be to understand the relationships between these variables. Key Responsibilities: - Utilize the provided dataset to develop a causal model - Ensure that the model is capable of effectively illustrating relationships between variables - Optimize the model for performance Ideal Candidate: - Proficient in Machine Learning and Python - Experience with building causal models - must have worked on techniques like robust synthetic control, dowhy, econml, trigamite, DECI and other double ML/c...

...individuals who are task oriented and can assist in saving audio documents from online databases with full permissions. Your main task is to focus on downloading and saving audio files smoothly and efficiently. Main responsibility: - Download audio files with full permissions from the online database provided. - Ensure all downloaded files are in audio file format and properly labeled according to instructions. - Save these audio files to your personal Dropbox account which has a minimum capacity of 1TB. Qualification: - Experience and proficiency in storing and managing files in Dropbox. - Have a Dropbox account with a minimum storage capacity of 1TB. - Exceptional attention to detail to ensure each file is stored properl...

...web scraping and data analysis firms to conduct a comprehensive data collection and analysis project. The purpose of this project is to gather detailed information on menu items, pricing, customer ratings, promotions, and deals from various food delivery mobile apps operating within our city. The goal is to mine this data for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and associated promotions or deals. • Move systematica...

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

...on PHP and I'm looking to integrate it with APIs provided by multiple suppliers. These suppliers will send us three specific types of data through their APIs - customer information, product information, and order information. Key Requirements: - Connect the webapp with Supplier A, Supplier B, and Supplier C APIs. - Extract and process customer information, product information, and order information sent by these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - Detail-oriented to ensure accurate data extraction and...