Recent content by mcmuppet

CJ, That worked perfectly and I would have never got to that answer! Many thanks for your help

Hi Here is the full SQL: SELECT MyTable.Brand, MyTable.ID FROM MyTable WHERE (((MyTable.Brand)=IIf([Forms]![MyForm]![Brand]='(All)',[MyTable]![Brand],IIf([Forms]![MyForm]![Brand]='Brand1 & Brand2',"Brand1" Or "Brand2",[Forms]![MyForm]![Brand])))) AND ((MyTable.Live)='Yes'));

Hello I have a combo box as a value list and all the values apart from one are valid data entries in the table but I want to combine two of the values and then get the query to run if the combined values are selected. The value list is this: (All);Brand1;Brand2;Brand1 &...

Essentially the difference between the two tables is the larger one has the data split by date and segment, the smaller table just has date. So I am doing the DSum to update the smaller table with the data from the larger table. I have two links, one on date and one on LU and the criteria is...

Because my low level data has c.5 million records and I need users to be able to query that when they need to but mostly they will only need high level data so thats why I am creating the summary table, this will only be a few thousand records

Hello I have two tables, one with the lowest level of data and one with summary data. Both have a date and ID field and I have linked these together in the query. I want to update a field in the summary table based on the sum of the data in the low level table. Here is my SQL: UPDATE...

Hi I have some code where I am deleting rows in Excel and using the Excel replace function however it doesnt seem to work. The code in red is where it fails. Can anyone help me out on where its going wrong? Thanks Martin Set XL = CreateObject("Excel.Application")...