ellistyle@gmail.com
New Member
I have a "form" whose function is to gather qualitative input. Quantitative data is prepopulated and if certain criteria are met, a comment is to be entered. Here is a simple representation of the form data. Column D is what I want to capture and archive.
Form data from 5/1/22
It is simple enough to create a query that pulls this data in--basically copying the table. I want to create a query that captures this, adds a date stamp (or some designation), then tomorrow or next month when the form is filled out again, the existing data in the form is blanked out, new data is entered and whatever is now in the form is appended to the query with a new date stamp. The form is not deployed, so I will be managing the inputs. I don't need to automate the blanking out. I just want to refresh the append query and see the new form inputs populated. I prefer to keep the form and the query result in the same workbook, but that isn't explicitly necessary.
Am I making this harder than it should be?
This is the result I'd be looking for given another day of input:
Form data from 5/2/22
Desired append query result:
Form data from 5/1/22
| Product | Forecast | Actual | Comment |
| Widget A | 2000 | 1700 | Missed target due to whatever blah blah |
| Widget B | 1500 | 1500 | Some other blah blah blah |
It is simple enough to create a query that pulls this data in--basically copying the table. I want to create a query that captures this, adds a date stamp (or some designation), then tomorrow or next month when the form is filled out again, the existing data in the form is blanked out, new data is entered and whatever is now in the form is appended to the query with a new date stamp. The form is not deployed, so I will be managing the inputs. I don't need to automate the blanking out. I just want to refresh the append query and see the new form inputs populated. I prefer to keep the form and the query result in the same workbook, but that isn't explicitly necessary.
Am I making this harder than it should be?
This is the result I'd be looking for given another day of input:
Form data from 5/2/22
| Product | Forecast | Actual | Comment |
| Widget A | 10 | 15 | blah bah |
Desired append query result:
| Product | Forecast | Actual | Comment | Date Stamp |
| Widget A | 2000 | 1700 | Missed target due to whatever blah blah | 5/1/22 |
| WidgetB | 1500 | 1500 | Some other blah blah blah | 5/1/22 |
| Widget A | 10 | 15 | blah bah | 5/2/22 |
