Lost your password?

Category Employer Location Date
XML Programming GaryP Sioux City 07-01

MS Access - Matrix of Account Numbers
My manufacturing company receives orders from thousands of accounts. For some orders we have to use their unique customer numbers with up to 100 vendors to supply parts and have them drop shipped them to us, while the charge goes directly to their account with the specific vendor. I get a text file export from our ordering system that groups daily orders by vendor. Each vendorís order will have multiple orders from our account list that require their unique customer numbers to complete the orders. I have three tables; an account list of 8000 accounts with their account codes, names, addresses, etc. Another table with the 100 vendorsí information and a third table that contains our accountís code and their unique customer number required to order parts (about 9200 records). I had the whole thing working with sample data but I canít import the tables with large amounts of data because of the lookups I created when building the tables. I donít have time to complete this. I need the tables to be updatable by importing from MS Excel, I will complete everything after the relationships are set up. I prefer to use MS Access for this because I will want to alter it.

Login to inquire about this project

Here are some of the content and language terms that exist throughout this website

Freelancers, Freelancer, Freelancers USA, Get A Freelancer, PHP Programmers, ASP Programmers, Web Designers, Graphic Design, Logo Design, Java, Javascript, Linux, Windows, Cold Fusion, Visual Basic, Flash, .NET, Link Building, E-Commerce, PHP, ASP, Banner Design, Data Entry, Joomla, Perl/CGI, CMS, Content Management System, Script Installation, Visual Basic, Windows, AJAX, C/C++, Data Processing, J2EE, JSP, SEO, Search Engine Optimization, Web Promotion, Photoshop, Dreamweaver, Python, XML, XHTML, Web Design, PHP programming, ASP programming, Database Programming, Internet Consulting, web design Freelancers,PHP Freelancers, ASP Freelancers, Freelancer Directory, Get a freelancer, find a freelancer, find freelancers, get web development projects, outsource programmers php, outsource, outsource America, outsource American freelancers, don't get scammed by freelancers