I would like to create an Access form or code that would ask the following.
What type of fields do you want data for:
3) Multiple ppty_ids
Based on the above selection, then if a person selects #3 it would say:
Please enter the multiple ppty_ids you want data for:
Then the query would execute with the above criteria, and would output to an Excel file, SvyData.xlsx.
Query is in attached Access file.
Could someone please help with how to do this?