Search results

  1. M

    Table reformat based on criteria

    Hello, I don't know if this is possible and is probably complex, but I receive an excel spreadsheet of our investments. The sheet is really clumsy but it's consistent. So I was hoping to import it into Access then have a query strip out just what I need. I.e...
  2. M

    Clean Month & Year to Date Qry

    Hello ALL, I have the below financial data showing each acounts monthly figures: Period.....Account....Monthly£ 01 ........1000 ........£500 01 ........1005 ........£40 01 ........1011 ........£1,200 02 ........1000 ........£20 02 ........1005 ........£100 02 ........1011 ........£20 03...
Back
Top Bottom