Question Min/Max and multiplication

[ozdemirozgur]

Hi,

I have a table which has some sale data such as

Table1!a, Table1!b, Table1!c etc. I would like to get the minimum of a, b, and c for the same record and also the multiplication - however some fields are empty and in case of having an empty field it should not be part of the multiplication and in case of having min and max, system should treat them like zeros. will be happy if you can help.

thanks, Ozgur

 

[vbaInet]

The way you are looking to do this will require creating your own Min() function because the in-built Min() function in Access works in a row-wise, not column-wise.

The mulitplication part is simple enough. You can use Nz([a], 0) * Nz(, 0) * Nz([c], 0)