I have a form that calculates daily cash register totals. One subtotal is for cash [Cash_Tot], based on quantities of denominations. Second subtotal is a control referencing an embedded subform's footer total for check amounts.
Summing both controls give me a daily total. Im trying to create a query and report showing the monthly totals but cant find a way to get these calculated controls into a query or report. Does anyone know how i can do this?
Summing both controls give me a daily total. Im trying to create a query and report showing the monthly totals but cant find a way to get these calculated controls into a query or report. Does anyone know how i can do this?
