415765 Create report from SQL data

I have various SQL databases that I need to interrogate to create a report returning a range of information. I need an interface created, maybe in Access, that allows me to enter a few variables, such as a date range. The process will involve references to approximately 8 tables within the SQL data. The interface should also allow me to determine what database I link to, as there will be up to 50 databases residing within SQL Server 2005. They all have the same table configuration, so the data locations will always be the same.