Ms Access Sql Expert

I have a 1.9M record DB. I am trying to delete 600K duplicates based on one of the fields. I've tried several different ways, which generate error messages or do not work. It's less than 15 minutes work for an MS Access DB Expert.

I have a 1.9M record DB. I am trying to delete 600K duplicates based on one of the fields. I've tried several different ways, which generate error messages or do not work. It's less than 15 minutes work for an MS Access DB Expert.

Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)

I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50

Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.

Thanks

Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)

I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50

Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.

Thanks

We use an MS Access-based application to track our business activity (inbound shipments, inventory, outbound shipments) and we need some custom views from which to view and edit data. The first phase of work should take about 2 weeks, then there may be more work after that.

---

Additional Info (Added 9/25/2008 at 13:55 EST)...Hoping to find someone in Orange County, CA so we can meet face-to-face re: the project.

st need to provide the database design, the font-End desktop GUI for the queries, view results and export to delimited files

Full details are in the Attached PDF file

If you have questions after reading the PDF send me a PM

---

Additional Info (Added 8/9/2010 at 1:16 EST)...System Message: This is a reposting of project Database Design SQL MS Access MySQL (1279196219).

you know what you are doing.

I've spent hours waiting for people to complete this job only for them to admit they can't do it.

I cannot mess around with this. I must watch you working on teamviewer so that I know you know what you are doing!!!!!!!!!!!!!

If you can do this, there will be more work.

If you apply for this job and cannot do it I will leave negative feedback.

You must have skype and teamviewer and be available for work NOW.

ters are configured. Once i manage to get it to work, it works fine all the time after that. Trouble is I've never actually figured out what I need to do, or have done previously that makes it work.

What am I missing?
I want someone that knows exactly what I am talking about and knows the fix!
They have to be able to explain it to me so I know what I'm missing and I can then do it myself next time!

Thanks,
Robert

ith MS Access.Because i do not know enough VBA and programming access i need somebody that will help me take this project to end, help me correct some bugs and program some functionalities , create some reports and queries . The database i have is in Portuguese.I want someone available right now and need somebody with time to dedicate to this project because i need to finish it untill next sunday.

A small project dealing with MS ACCESS 2007 and SQL Server express 2005 -- required to design labels, worksheets and reports.

"Must have some rating on this project".
Requirement : Urgent

ject. I will ignore silly bids.

Applications possible to use for this Project
MS Acess, SQL server on local offline PC, MySQL PHP Lamp running on WAMP on local offline PC. I will have one or the other installed here. You just need to provide the database design, the font-End desktop GUI for the queries, view results and export to delimited files

Full details are in the Attached PDF file

If you have questions after reading the PDF send me a PM

i want someone who is an expert at ms access. i have a database in access. i want someone to fix minor errors like autonumber ID reset, fix random messages. combine 2 databases

bid only if you can do this right now. i am online

i will give you $ 10 for this

ne runtime to run via terminal services.

Here is a description of the databse application:

- 120 tables with approx 2000 columns
- 720 views, stored procedures and SQL functions
- 180 forms and subforms
- 150 reports and subreports
- 26 general purpose modules
- 120 class modules
- estimated 200 lines of code for each form, general purpose and class module = 60K lines of VBA code

We have a custom built coldfusion website and CMS currently running on Access 2000 DB. We need site to run on SQL server DB. You must migrate all data to SQL DB and change connection strings in website code so that the site runs on SQL server. Site must be fully tested and functional on new DB.

– this will have to be part of the job quoted on.

This work must be completed using MS technology – i.e. sticking with the MS SQL Server, ASP.NET etc.

* DO NOT BID if you do not have experience with a similar project, turning Access Database into ASP.NET web based database
* DO NOT BID if you intend to change your mind about your price as soon as I accept you offer.
* DO ask me any necessary questions before bidding

tag */-->


Additional files submitted: (Files are only available for logged in users)
WP-Frontend_Display_Changes3.docx

->


Additional files submitted: (Files are only available for logged in users)
WP-Frontend_Display_Changes_Abridged.docx

in 1a should be shown in the report. If the Truck was over capacity when you calculated 2a then show BlowOut as shown in the attached example

Please review the attachment and ask any questions you may have before bidding. I am looking for a commited developer willing to work on other projects after this one.


Happy bidding.

Regards

them in Access:

a) Sum of all sales in 2006
b) Number of sales in 2006

Task 2:
Use Access's built in Report Generator to produce these two reports:

- Produce a report showing all sales in 2006 sorted by size of orders
- Produce a report of all customers and their orders/purchases sorted by largest customers

Happy bidding

y and reporting.!!

In attached mdb results table contains mid marks of all subjects of students. I want to show these Nos in a style that subject name will become column heading or label and all the nos under his relevant heading.
The requirement is highlighted in the report with yellow color. It can be achieved by cross tab query, sub query or sub report & it is not more than 10-15 minutes assignment. I have developed everything only this minor part is remaining.