Hi All,
I'm not sure if what I want to do is possible, so I'm hoping one of you experts here can help.
I have a list box that shows a list of purchasing categories and their associated budgets. I have a separate table tracking the purchases that are made within each category. What I would like to do is have a third column in my list box that is a calculated column, that shows the sum of all spending within that category. I have written a query that returns the information that I need but I don't know how (or if it is possible) to get the listbox to show this as a separate column.
Additionally, the query that I have written uses hardcoded parameters as a test, but what I would like to do is use the returned value of the listbox (the bound column) as a parameter within the second query. So as the listbox is being built, it should return the first two columns of the query, then use the value of the first column in the query that subsequently populates the third column.
Am I mad for even thinking I can do this? If so, is there a far more sensible solution that I am missing?
Thanks all for any input you are able to offer.
Cheers,
Phil