I am trying to write a qry that does a simple minus calculation. To explain I have created two other qry's that sum two tables. These two qry's are called
qryTotalPayments = sums each clients total payments $
qryTotalOrders = sums each clients total orders $
I have checked the values in both these qry's and they look correct. The qryOutstandingAmount that I am having trouble with uses a join to linkboth qryTotalPayments & qryTotalOrders. The join type only includes rows where the joined field is equal.
The problem is the qry returns the values that look correct, ie people who have paid exactly what they have ordered show a $value of $0.00. The problem is if I click the cell that contains the value $0.00 the figure changes to 3.63797880709171E-12. Why on earth would this be happening? Thanks in advance for any pointers
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…