T
THANX LW
HI all,
I am confused with how to tackle dynamic query/Report situation.
I Have a simple query which has some fields from tables and then some
calculate fields and a report based on this query has a criteria form to
filter records, but every time report will be run some fields will stay the
same and there might be some additonal fields needed at run time.
can somebody please suggest an efficient way to tackle this problem.
I can think of only two options......either calculate all the possilbe
fields in a query and put all the fields on report but at run time make
unnecessary fields invisible(not that efficient i think)........or just
create the query and report with VBA(difficult options....will have to learn
how to do that).....
I appreciate all the help and suggestions......Thanks....
I am confused with how to tackle dynamic query/Report situation.
I Have a simple query which has some fields from tables and then some
calculate fields and a report based on this query has a criteria form to
filter records, but every time report will be run some fields will stay the
same and there might be some additonal fields needed at run time.
can somebody please suggest an efficient way to tackle this problem.
I can think of only two options......either calculate all the possilbe
fields in a query and put all the fields on report but at run time make
unnecessary fields invisible(not that efficient i think)........or just
create the query and report with VBA(difficult options....will have to learn
how to do that).....
I appreciate all the help and suggestions......Thanks....