I have a query which pulls data from two tables. I need to total the numbers in one field and place that number on a specific place on a report, not in the footer.
From what I have been able to figure out, it looks like I need to use the DSUM function in the query.
How do I do that? If DSUM isn't the correct function, what is and how do I do it?
From what I have been able to figure out, it looks like I need to use the DSUM function in the query.
How do I do that? If DSUM isn't the correct function, what is and how do I do it?