I gang

MsAccess CRM modification

Hello

I have a Ms Access database which among other things reflects the trade agreements with customers.

The trade agreement is reflected in an external system, we have a table with data that is maintained automatically.

Changes required - need to reflect a historical of these agreements in the Access database.

A trade agreement has such data (external data table):

Customer Cod

Provider Cod

Family Cod

Discount

We must reflect more data:

Date of load

Valid Date (it is the date since when the record is in the database)

Active

Logic:

Read the table of the external system, you should compare with data presented in the system and act according to different cases:

- first copy data from the earlier agreement on access and set status to "active" = NO in the old one

- compare data, if no the historical data - direct copy of data

- data is identical for the provider / family - no change required

- provider / family does not exist (for example, if it was cleared in the original system), then mark as "active" = "no" that record and leave discount to zero

- Discount for that provider / family have changed - change date value and discount.

Report:

1 - Print the final agreement in detail.

2 - Same as #1 but adding historical information

Aditional Form

I need a form that will display all the agreements with some filters (only pending, search by client, only active, etc)

This should work in Access 2007 or 2010. Layout will be provided (my actual database).

The application is in Spanish, instructions and additional information will be delivered in English. Field names are in Spanish.

Færdigheder: Microsoft Access, Visual Basic

Se mere: access crm, work in act, visual basic spanish, table customer, cod for, crm database access agreement, crm modification, microsoft access database modification, crm spanish, Crm Microsoft , cod, compare exist, microsoft client, 2010 access client database, application spanish, basic crm access, crm act, names spanish, crm microsoft access, modification form, reflects, trade report, access 2007 2010, field crm, compare table data

Om arbejdsgiveren:
( 67 bedømmelser ) Silla, Spain

Projekt-ID: #985248

Tildelt til:

Indispensable

As discussed. Thanks.

$100 USD in 2 dage
(8 bedømmelser)
4.5

7 freelancere byder i gennemsnit $164 for dette job

guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

$250 USD in 5 dage
(27 bedømmelser)
5.9
cyware

No milestone required. I'll do it in day, so you'll have plenty of time to test it.

$120 USD in 2 dage
(14 bedømmelser)
4.9
moutasem

i have a wide experience in MS Access and i can deliver this project perfectly

$150 USD in 5 dage
(0 bedømmelser)
0.0
mdaxini

hi there, i would like to this job . i have good knowledge of visual basic and ms access . please contact me asap. Thanks, md

$200 USD in 7 dage
(0 bedømmelser)
0.0
DesktopAppVN

Hi please check PM

$75 USD in 3 dage
(0 bedømmelser)
0.0
glanciault

I have 11 yrs+ of Access db coding experience; the enhancements you are requesting will not take much time to create and test. Thanks!

$250 USD in 2 dage
(0 bedømmelser)
0.0