Re-reading this today, it’s clearer, yet less clear.
I think we need to know more about the actual data that needs to be stored.
Why do we need an array of days (on insert)?
I think the lines are being blurred between what is required for the select data and what is required for the insert data.
Is the user form query triggering a select? Or, as it seems, is it triggering an insert? Or is the insert, putting the data into the database in the first place for the user selection?
Presumably, a “trade” is an event that happens at a particular time.
A single time an event happens can be recorded as Date Time or a Time Stamp.
I’m confused as to why you would need an array of days inserting for a “trade”. Unless the user form is resulting in an insert, as in you are recording what people are searching.