Displaying a listbox of info based on 2 parameters. How to average a listbox?

[krouchchocolate]

Hello,

I am trying to create a database that makes it easier to look for information based on the Serial Number and the date. How can I organize my 3rd listbox to only display information based on Listbox 2 (Items with the same serial number & also has to occur after that date).



Also, is there such thing as writing a command to average out a listbox? For example, I want to create another listbox underneath the 3rd one to average out what I circled.

[Robeen]

You can create a Query that does the Average calculation - and then base your Listbox on the Query.