I am looking for the simplest way to add text to a record. I have a database that gets its data from linked excel tables. All the table fields are identical. I have done a union query to go through all the tables and find records by a specific field using an input form. It returns a perfect query list as it should. My problem is now that I would like to add text to the records but each record will have different text added. The end result will be that I generate a report from the data inclusive of the added text and then I will e-mail that report.
This data equates to raw materials. I want to be able to search for one or multiple materials. I have that accomplished. Now that I have the list of items, I want to be able to go to each item and have the user type in plain text where this item should go to and how many of each. When the user types that in, I want to generate a report and e-mail that to the material controller. The added text and qty does not need to be retained within the database if that will help, however it does need to be on the same report that is e-mailed.
Thank you in advance for any ideas. My SQL ability is low. It exists, but is nothing to write home about so feel free to advise any SQL programming as if I were a cucumber. Thank you for your time.
Also as an attempt I created an unbound text box on the form after the query but that returned that each record had the same data as the first record in the text box.
This data equates to raw materials. I want to be able to search for one or multiple materials. I have that accomplished. Now that I have the list of items, I want to be able to go to each item and have the user type in plain text where this item should go to and how many of each. When the user types that in, I want to generate a report and e-mail that to the material controller. The added text and qty does not need to be retained within the database if that will help, however it does need to be on the same report that is e-mailed.
Thank you in advance for any ideas. My SQL ability is low. It exists, but is nothing to write home about so feel free to advise any SQL programming as if I were a cucumber. Thank you for your time.
Also as an attempt I created an unbound text box on the form after the query but that returned that each record had the same data as the first record in the text box.
Last edited:
