1
1-acxi-1
Hello, I'm using Access for some reporting and I'm trying to pull in
some dynamic fields that are beyond what's assigned in my data source
(which is one big master query). This report pulls is uses a key
parameter to populate the report with a distinct record, however there
are some fields which will change per match. Basically I'm trying to
see if there is a way to have more than one data source or (and this
may be better) a way to pull in a field 'on the fly' using a text box
and an expression? (i tried this and it let me drill down to the
standalone field in question but when I'd preview the report it prompts
me for that field as a parameter)
Any help would be greatly appreciated, thanks!
some dynamic fields that are beyond what's assigned in my data source
(which is one big master query). This report pulls is uses a key
parameter to populate the report with a distinct record, however there
are some fields which will change per match. Basically I'm trying to
see if there is a way to have more than one data source or (and this
may be better) a way to pull in a field 'on the fly' using a text box
and an expression? (i tried this and it let me drill down to the
standalone field in question but when I'd preview the report it prompts
me for that field as a parameter)
Any help would be greatly appreciated, thanks!