Here is what I would like to do. I play in a softball league which plays 7 weeks per season. Each Week we play a doubleheader. I want to create team specific stats thus standings but having trouble figuring out how to make the following example work:
I am extracting data from an SQL database into Excel 2007 using MS Query.
I've used the following SQL code to prompt for the parameter:
casosdeuda.ConceptoDeuda LIKE (3) and
a.`TipoCaso` in (?,?) and
a.`TipoDeuda` in (?,?)"