Trying to create a Report, it's source is a query "QSpecificYear"
Depending on which year is picked on a Form, the names of two fields in the query change.
Example:
If year 2013, the field names are ... FirstName,LastName,PledgedAmount,2,3
If year 2014, the field names are ... FirstName,LastName,PledgedAmount,4,5
For Control Source in the Report can use something like a Column Number ... Column(4) instead of the name?
Thanks
Thanks
Depending on which year is picked on a Form, the names of two fields in the query change.
Example:
If year 2013, the field names are ... FirstName,LastName,PledgedAmount,2,3
If year 2014, the field names are ... FirstName,LastName,PledgedAmount,4,5
For Control Source in the Report can use something like a Column Number ... Column(4) instead of the name?
Thanks
Thanks