You have chosen to sponsor your bid up to a maximum amount of .
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.