Search results

  1. C

    Simple Append if not exist

    OK I think I may have the root cause of my issue... You cannot change, add, or delete data in tables that are linked to an Excel workbook. http://support.microsoft.com/kb/904953/en-us time to rethink my problem UPDATE: yep problem solved... Thank you very much everyone who took the time to...
  2. C

    Simple Append if not exist

    Hi CJ London Apologies, I ended up leaving work early on Friday so I have only just seen your help. Unfortunatly LEFT JOIN did not work I have made a small change but I still get no select, however using your LEFT JOIN I now get A message box to Enter tblForecastMaster Parameter Value...
  3. C

    Simple Append if not exist

    It seems today that everyuthing I am trying to do smacks me around the face... I have tblForcastMaster which is updated monthly via an Excel Linked table ForecastUpdate Both tables have the same fields firstly a query is run that will update all existing forecast multipliers with ammended...
  4. C

    Simple delete query

    OK That worked, but it just deleted without any warnings, The numbers tally so hopefully its alright.
  5. C

    Simple delete query

    yes a select works perfectly SELECT [tblmaster].* FROM [tblMaster] INNER JOIN [001 tblMaster Without Matching tblProducts] ON [tblMaster].UID = [001 tblMaster Without Matching tblProducts].UID; does it matter that 001 tblMaster Without Matching tblProducts is a query?
  6. C

    Simple delete query

    pr2-eugin - unfortunatly not but thanks for the heads up. I now get the message Could not delete from specified tables. DELETE tblMaster.* FROM [tblMaster] INNER JOIN [001 tblMaster Without Matching tblProducts] ON [tblMaster].UID = [001 tblMaster Without Matching tblProducts].UID;
  7. C

    Simple delete query

    My database now has a table of acceptable products My Master table tblMaster has a load of records that need to be cleared out, as they are not in tblProducts. My new upload method should take care of this in the future. I have run the "Find Unmatched Query Wizard" to get a list of all the...
  8. C

    Return values record -n

    Thank you I will let you know if I get it to work.
  9. C

    Return values record -n

    I killed it in the end, so 30 mins to run and I got worried. It will be run many many times, apologies for the bad news, but a brave attempt as you have no idea of my work load. ==== I meant to add I looked at this SELECT * FROM (SELECT TOP 4 * FROM qryPeriod ORDER BY Period DESC)...
  10. C

    Return values record -n

    plog That is an amazing feat of work, I owe you so much gratitude. Not sure what is going on with my laptop but running "qryPeriodRanks" has caused a major stall in Access it is taking an age to run. tblMaster has around 1.5M records in it maybe thats the problem. The data is in the process...
  11. C

    Return values record -n

    I have a grouped query that returns a list of all periods qryPeriod SELECT [tblMaster].Year, [tblMaster].Week, ([Year] & " - " & Right(0 & [Week],2)) AS Period FROM [tblMaster] GROUP BY [tblMaster].Year, [tblMaster].Week, ([Year] & " - " & Right(0 & [Week],2)); Year | Week | Period 2013...
  12. C

    return one value or another

    Good Grief! Hi CazB Correct 'solo' means it's one colour only (but you only know which one by looking through all the available colours!) Multi means it is made up on more than one colour... again you would only know which ones by looking at all the fields For my exercise There is a single...
  13. C

    return one value or another

    jdraw You are correct, but the dilema is I need to know how many yellow widgets were sold including those within a mutipack.
  14. C

    return one value or another

    OK using your influence I have got this to work Colour: IIf([PACKAGE TYPE]="multi","multi",Trim$([Red] & [Yellow] & [Blue]))
  15. C

    return one value or another

    Yeah, I agree, the colours probably arent actually 200+ but it makes the point that I didnt want to count them all. However to answer your question, this file is a report from another database which spits it out like that, so in essence there are a lot of empty fields. In hindsite It would...
  16. C

    return one value or another

    Hi CazB Thanks for your suggestion, however i get an error that says "The expression you entered has a function with the wrong number of arguments." That is before I add in all (200+) possible colours ha ha ha! just thought I'd try it with the example 3 NB the observent amoung you will...
  17. C

    return one value or another

    I am looking up a product based on a unique code in tblProducts I need to return one of two values If the value of [Product type] = "multi" then return "multi" else If the value of [Product type] = "solo" then return the value of the non empty field in a range of fields for example...
  18. C

    return char number value as numeric

    Hi manliam it was returning the values as text. However, wrapping VAL around it has now produced numeric values. I think this will work now, just working on the rest of query
  19. C

    return char number value as numeric

    I have tried to use a bit of code so return the Last Year and WeekNo in my database, to select some records but…. It currently fails, I think this because it returns the values as text and will then not compare to a numeric field. Is there an easy way to change this code so it returns numbers...
  20. C

    Display a count of "Type"

    OK Ive changed the field name to [Package Type] but still getting #Error
Back
Top Bottom