Search results

  1. M

    Combo box result and iif statement

    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 &...
  2. M

    Update query using DSum and 3 (three) criteria

    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...
  3. M

    replace function in Excel

    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")...
Back
Top Bottom