- Status Completed
- Budget $10 - $30 USD
- Total Bids 5
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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online