Coupon Finder/Creator

  • Status Completed
  • Budget $10 - $30 USD
  • Total Bids 5

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:


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.

Get free quotes for a project like this
Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online