Search results

The reason it isn't showing you all records is because you need to change the join properties of the two tables you are comparing. It either needs to be option 2 or option 3 depending how your tables are set up. By changing this you are telling the qeury to show results including records that...

LOL, looks like you and I have the same problem (see above post - Converting null values)... and good timing! :p

If a query finds a null value is It possible to write an expression that will change it to a default value like zero? As you can see from my query results VPO 333333 has a null for 'SumOfVPOAmount'. This is because I payment has not yet been made against that VPO. The purpose of this database is...

I've created a database to track payments made to vendors for Purchase Orders. In the database VPOs are paid by PaymentID and there can be more than 1 VPO in a payment ID. The problem I'm having now is that when I try to query the total balance on one or multiple VPOs, it's only showing me the...