asaidi
asked on
add second query in report using access
Hi
i have a report that is connected to query1 and i created second query that calculates total and i want to add a field from this query to the report ..
can i add table or query to my report without creating second report ..
i have a report that is connected to query1 and i created second query that calculates total and i want to add a field from this query to the report ..
can i add table or query to my report without creating second report ..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DLookup("field name in your sum query", "sum query name")
The above goes into the control source of your textbox.
The above goes into the control source of your textbox.
ASKER
Hi
thank you Emil i will try this as second option because the first option sent by matthewspatrick is working
thank you Emil i will try this as second option because the first option sent by matthewspatrick is working
If Patricks solution works then he gets the credit and points.
ASKER
i add an unbound textbox
then i wrote select sum(total) as total from total
and total it is a query that i made in query section
but everytimes i close it is not saved and i clicked on save option but still the sql is not saved