Search results

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

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

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'...

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

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

Hi, New poster, new to the forum, new to access vba. Have created a vba module that takes all named reports assigned to any one of 150 and emails a spreadsheet listing all the reports to the recipient. The issue is that when it arrives, it’s all scrunched up and I can’t seem to see if...