Hello. Is there a way to solicit user input and use that input to create a table name in a query? For example, when the query asks for the parameter, the user enters for parameter 'year', "2021". The Access query then builds a table name as "Table " + year, resulting in a table name 'Table 2021'. The query would then use that name to insert records into that table.
Thanks.
Thanks.