Search results

  1. L

    Banding data

    morning all I have a list of values that I would like to put easily into bands like 0-100 101-200 201-300 If there something easy I can do, and i have values ranging from 0 to 25,000 Thanks
  2. L

    Missing sequential numbers

    hi all I have a list of what should be sequentaia numbers, but I am finding instances were a number seems to be missing Is there a way to query the whole dataset and find all missing instances without having to trawl he list? Thanks Lee
  3. L

    Multiple @if statements

    morning all I have the following data set: Name Date Start PostCode EndPostcode I have sorted the data by Name and Date I want to be able to say that if the Name is the same as the Previous Record, and the Date is the same as the previosu record, then the Start PostCode is the End...
  4. L

    The day of the Week

    Hi all I have a list of dates on which tasks were performed. I want to be able to see if there is a pattern, i.e. lots done on a Monday Can I extract the Day from the date, and return a value Monday, Tuesday, Wednesday etc?? Thanks
  5. L

    Extract PostCode

    Hi all I have a table with a string field included for an address. Some rows have postcodes and some dont How can I extract the PostCode values from the field please?? Thanks
  6. L

    Access Dashboards

    Hi all Am looking for a good product to produce the above Any suggestions please? Thanks
  7. L

    Distance in Miles

    Good afternoon I have a list postcodes and need to work out the distance between them. Can anyone recommend a good program, or has anyone done something similar please? THanks
  8. L

    Find latest date

    Good afternoon I have a list of project, each of which have dates which work were carried out on them. Each project can have more than one date. I want to be able to find the last date that any work was carried out, and then calculate how many days have passed since that happened. All help...
Back
Top Bottom