Recent content by Chrishill

Query In the control source I have got it to work using VBA I now hide the subreport if no data is availible and display "nothing shipped" otherwise I show the total shipped values.

thanks you for the syntax - i tried it and still get #error when an order has not had any thing shipped againt it the subreport is not there. So when i ask it to compute a value I get an #error. I think i need to make the sub report invsible so no #error is returned, but i do not know how to do...

Hello, I would like to have the user select (from a drop down list) the parameters for a report. I have been sucessful doing this through a queria and setting the criteria, where a pop up asks the user to enter the parameter. I want to get multiple paramaters from two or three drop down menu...

thank - you for the reply i tried the Nz function, but i still got an #error - there is no variable to null. what i have had the best luck with is trying to differentiate between a number and a #error in an IIF statement??? still not working - where would you use the Nz??

Hello, I have crated a simple database to organize "orders", "shipped" and "pending" Problem: The pending report does not work if i have not shipped against the order. the report is grouped by product then "order" and has a sub report calling up the shipped against value for each order. the...