Hi -
I orginially created a report that runs off a single query. (User selects project value that drives the initial query. The report displays # hours billed to a project per month). Now managers wanted me to add $$ values to the existing report. To save time, I created 2 additional queries that get the summarized dollar values. I was having trouble adding the amounts directly from the query to the report so I created forms. From the forms I was able to add fields to hold summarized $ amounts. But I have one problem....
the report will display #Name? in the summarized dollar value fields if the new forms are not open in the background.
Is there a way to load the values from the forms without having the forms open?
Thanks!
Lissa
I orginially created a report that runs off a single query. (User selects project value that drives the initial query. The report displays # hours billed to a project per month). Now managers wanted me to add $$ values to the existing report. To save time, I created 2 additional queries that get the summarized dollar values. I was having trouble adding the amounts directly from the query to the report so I created forms. From the forms I was able to add fields to hold summarized $ amounts. But I have one problem....
the report will display #Name? in the summarized dollar value fields if the new forms are not open in the background.
Is there a way to load the values from the forms without having the forms open?
Thanks!
Lissa
