Search results

The calculated field worked great. Cheers

I've got a pivot table that has date down the side and sales, costs and margin as the values. I want to add another value that is margin/sales that changes as and when the pivot does. I've tried using the custom calculations but I'm not having much luck - any ideas? Cheers

Getting there! It now comes up with You tried to execute a query that does not include the specific expression '(Z0010_select_only_sales.company=forms!form2!cpyCombo or forms!form2!cpyCombo Is Null) AND (etc....... The whole SQL is sql_string = "INSERT INTO grp1Source ( Channel, [SumOfGross...

I'm using a form with combo boxes to apply filters on an append query. I have used the following SQL instruction that works if I run as a query but if I run in VB using CurrentDb.Execute(SQL string) I get the following error. Run time error '3122': You tried to execute a query that does not...

That's great. Cheers for your help.

Yep. I've got 4 combo boxes, mthCombo;yrCombo;cmpCombo;chnCombo populated from 4 tables of similar names to create the list. month and year a defaulted to the current month and year. So the SQL would start, for example SELECT sales_revenue FROM orderDetail WHERE........ Where the 4 combo boxes...

I forgot to mention that if no company or channel is selected then it'll recognise that all company's and all channels should be included.

Yeah, the filters I want are month, year, company and channel. From that I want to use them as criteria in a make table query using a table called orderDetail - does that make sense?

I'm trying to use a set of combo boxes to act as filters. Once the user has chosen the different filters I then want to pass these into a make table query. I'm currently using a piece of code to append the string value for the combo box to another string to create a SQL instruction - is there a...