Search results

  1. E

    Criteria and aggregation in a query

    Hi all, I am trying to use criteria for Product column (i.e keep only product A) Total for Sales column to aggregate the values and it seems that is cannot be done simultaneously. Product Sales A 34 A 45 B 21 A 11 B 23...
  2. E

    Problem with #error in Date column

    Hi all, I am experiencing a problem which seems so simple but eventually so hard to do. I have a column with Dates as string. I want to convert this column to date which I managed to do as seen below. Eventually I want to replace the #error with an empty cell. If Date column is formatted as...
  3. E

    How to do a join range query

    Hi all I am currently trying to do a range join query in access (not an expert at all with it) but I realized that it’s not easy. It probably needs a VBA code but still not sure how to do it. I basically have a column with number of days e.g Number of days 18 1 0 56 8 -19 369 Eventually I...
Back
Top Bottom