Hi, I have a Marketing database in which are 2 tables, one called "Purchases" and the other called "smsout". I have a query called "promo" which extracts all records from the cellular number field called "SMS" from the "purchases" table. The query as seen below is based on those customers who have bought items from a particular category:
SELECT Customer.SMS
FROM Customer INNER JOIN purchase ON Customer.ID = purchase.[Customer ID]
WHERE (((purchase.Item) Like "Flowers"));
My question is this, I would like to create an Update/Create query that would transfer the results of the "promo" query into a new table called "smsout1" with the following fields:
* "From" - which would be automatically populated with my contact number (i.e. 07958356777) for every record in the new table.
* "To" - which would be where the numbers from the promo query would be extracted to.
* "Message" - which is the message I would be sending to them.
I have tried to create an update query for this with no joy.
SELECT Customer.SMS
FROM Customer INNER JOIN purchase ON Customer.ID = purchase.[Customer ID]
WHERE (((purchase.Item) Like "Flowers"));
My question is this, I would like to create an Update/Create query that would transfer the results of the "promo" query into a new table called "smsout1" with the following fields:
* "From" - which would be automatically populated with my contact number (i.e. 07958356777) for every record in the new table.
* "To" - which would be where the numbers from the promo query would be extracted to.
* "Message" - which is the message I would be sending to them.
I have tried to create an update query for this with no joy.
