Simple sum method

[KenshiroUK]

I'm racking my brains with this one I have a table called inventory and I wish to add Quantity + Virtual Stock together in a simple select query. However it does not seem to display anything.

 

[pr2-eugin]

Hello KenshiroUK, Could you please show the Query you are using?

 

[KenshiroUK]

Hello KenshiroUK, Could you please show the Query you are using?

Hi I have just figured it out.

I used Total Stock: Nz([Quantity],0)+Nz([Virtual Stock],0) and it worked.

 

[pr2-eugin]

Glad you have it sorted all on your own..