Search results

Thanks pbaldy! The IsNumeric test did the trick. I revised the expression in the SumofSums field on the main form to be: =IIf(IsNumeric([LaborSubreportforJobcost].[Report]![SumOfLaborDollars]),[Sales]-[Purchases]-[Labor],[Sales]-[Purchases]) The SumofSums field now displays the correct total...

I have a report called JobCost. JobCost has three subreports: Sales, Purchases and Labor. Each subreport calculates and displays a total. These fields are called: SumofSales, SumofPurchases and SumofLabor. I have a field on the main report that calculates and displays the Sum of these sums...

Hello All! Just wanted to say hi and let you know a little about me. I'm an accounting manager and have been designed and using Access database projects since 2000. My VBA skills aren't what they should be but I'll be brushing up on that. I hear VB6 is a good starting point for learning VBA...