KristieLee1
Technical User
Hello. I am working on a 'report' in access that will be exported to excel. The end users do not have access, hence the excel medium. I'm trying to create as much as I can in access.
So, I have 30 columns of information. Each column will need a drop down box for the user to select an option. Each column will have different selections in the drop downs. Is there any way I can create the drop downs in Access, that will then export to excel?
I am creating a query off a table in access. I will need to create columns within the query that display the drop down choices (as the columns do not exist in the table being queried---I know I know).
Ideas? Any help is appreciated. Thank you!
So, I have 30 columns of information. Each column will need a drop down box for the user to select an option. Each column will have different selections in the drop downs. Is there any way I can create the drop downs in Access, that will then export to excel?
I am creating a query off a table in access. I will need to create columns within the query that display the drop down choices (as the columns do not exist in the table being queried---I know I know).
Ideas? Any help is appreciated. Thank you!