Recent content by PNEfinney

  1. P

    Solved Nested iif?

    Thank you, id clean forgotten about Switch Appreciate you posting this, TY EDIT: This did exactly what i needed to, i just switched the order so Dec was at front of the expression,and it worked backwards. Thank you for all your help.
  2. P

    Solved Nested iif?

    i wasnt adapting the formula so much as the intention, if that makes sense. in my initial formula I used 'Is Null', but ill try your suggestion. Thank you.
  3. P

    Solved Nested iif?

    Thanks for replying. In explanation i sent reports out to a third party who would update records in an Oracle system. where the update went well, they added a new column 'Status' that would have 'Complete' or if not complete, '*the reason it failed* These were done on a regular basis, monthly...
  4. P

    Solved Nested iif?

    hi, hoping you can all help. I am possibly being a bit naive in thinking i can transfer an 'if' design from EXCEL into ACCESS; I essentially want to do waht this does in access: =IF($BD2="",IF($AW2="",IF($AO2="",IF($AH2="",IF($AD2="","",$AD2),$AH2),$AO2),$AW2),$BD2) I want access to look...
  5. P

    iif and Partial Decimal

    They both work beautifully, thank you. I just have to go and backwards engineer what the query is so i can use it again.
  6. P

    iif and Partial Decimal

    Hi all, should be a quick one, but its being a bit of a pain. I have a field that is number format showing a duration. There are some in this field that contain decimals, which are always halves, ie. .5 but the whole number can be anything (I have 14.5, 7.5, 20.5 etc.) using this iif I can...
  7. P

    'Year' Wildcard?

    Hi all, I need to classify time elapsed from a date and give it a classification so it can then lookup into an adjoined table and return a specified value. At its basic it will look at a date, for e.g.: 01/01/2018 and subtract that from 01/01/2021 and it will return the class '03 Years'...
  8. P

    Linking within query

    Hi all, I tried searching but dont know the terminology; I have a Base Data Table that has a Code in one field, then a Holiday Entitlement assigned to that code in the next field. In a Query i have concat two fields to give me a Code that i want to connect to the Base Data table Code and...
  9. P

    Transposing one column

    Hi, dont know the terminology to use so havent had any luck searching. I have a list of people and who they report into in two columns on a report. Obviously in the manager column it reports multiple instances of the manager. What i want is one line where the first column is the manager, but...
  10. P

    can't change anything in query property sheet

    ok, cant upload anything as it is sensitive data. Ill keep trawling the internet.
  11. P

    can't change anything in query property sheet

    Appreciate your help, though I disagree that its entirely a different question. Whenever I create a query from a table, the query will not allow me to amend the field properties, nor does it bring in the format from the table I am querying on. All I can see is the blacked out version I posted...
  12. P

    can't change anything in query property sheet

    the table that I’m pulling into the query has that field as a date field, I’m pulling a format query on the date field but I can’t see what format myquery is formatting on because when I click on the drop down in properties it opens up a drop down that is blank and won’t populate with anything...
  13. P

    can't change anything in query property sheet

    Version ACCESS 2016 (latest one, not 365) Can’t ascertain in aces what type, but when copied into excel, it comes through as General. When I click in the right hand side, I get the All enabled.
  14. P

    can't change anything in query property sheet

    Thanks for the advice on the code, cant believe I didn't think of that, especially after wrapping the above code in it!! for the view, this is what I get:
  15. P

    can't change anything in query property sheet

    can you believe that a year to the date im searching on this forum for the same issue. However, none of the steps above fixed this. No matter what movement or sizing I do to the properties, I cant get the options to populate, just blank. Is there a setting that has turned these off? As...
Top Bottom