Coupon Finder/Creator

IN PROGRESS
Bids
5
Avg Bid (USD)
$47
Project Budget (USD)
$10 - $30

Project 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 required:
Microsoft Access
Additional Files: Coupons.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 66
in 1 days
$ 84
in 1 days
$ 35
in 1 days
$ 15
in 1 days
Hire Pharoa
$ 35
in 2 days
Hire expertlogix
$ 53
in 1 days