Coupon Finder/Creator

Closed

Description

I want to advertise services that have not been used by my current clients.

There are 4 tables Involved.

JobType = List of all of our services

Contacts = List of our customers

Orders = All of the work previously done for the client

Calls = Communication with the customer (we will store the coupons given here)

I have currently created a Union Query (CouposAndServices) so that I can see all of the jobtypes used from orders and all of the coupons that have been given. What I need to do is Pull a jobtype that has not been used (or a coupon that has been sent in the last 6 months) at random from the remaining avaliable jobtypes and create a list for all of the customers so I can export that to excel for a mail merge.

so Each line of the list would look something like this:

ID,Name,Fname,Lname,Addr1,City,State,Zip,Coupon,CouponLocation

We also need to write the Coupon that is currently being issued to the Calls table with the date so that we don't use the same coupon next time.

Skills: Microsoft Access

See more: work finder, microsoft excel mail merge, id creator, i want to advertise, excel access table, access query table, customer merge, access query excel, microsoft merge, access table query, access merge table, access create query, random orders, pull orders, excel merge table, coupon used, creator access, create contacts list microsoft access, create list contacts microsoft access, customer orders excel, table creator access, customer coupon, name creator, excel excel mail merge, user will options look abbreviation look country name

Project ID: #5516219

Awarded to:

abdellatif81

Hello Rkellogg, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft d More

$84 USD in 1 day
(1 Review)
2.0

5 freelancers are bidding on average $47 for this job

Prashantskin

Res.Buyer I have gone through your project requirements. Please explain this further with explanation: What I need to do is Pull a jobtype that has not been used (or a coupon that has been sent in the last 6 mont More

$66 USD in 1 day
(467 Reviews)
6.9
anomanpk

Hi, I have read the description of your project and I would like to offer my services for this project. Over the last 10 years, i have done many projects on different languages and databases. I can show you my rec More

$35 USD in 1 day
(1 Review)
1.3
ReginFelll

Hi! Interested in your project. Am c # developer, but I love flask. Have extensive experience in drafting sql queries

$15 USD in 1 day
(0 Reviews)
0.0
Pharoa

I will bring very strong Ms Access and SQL Skills along with over 20 years programming experience to bear on this role. I am available and ready to begin immediately.

$35 USD in 2 days
(0 Reviews)
2.7
expertlogix

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More

$53 USD in 1 day
(0 Reviews)
0.0