Search results

  1. H

    How to get rid of the default chart?

    Hi all, I am still learning the reporting function of access. I am trying the chart function in report and unfortunately I can't change the default chart in the design page. What has gone wrong? Thanks, Henry
  2. H

    Access Lookup

    Hi, I am trying to play around with query but got stuck in fixing the bug. Please see attachment. I am trying to link the color code from a table to another table which stores the definition of color code. However, it gives me duplicate results. In Excel, this could be achieved by using...
  3. H

    How to add an additional column in query/table?

    Hi All, Could anyone tell me how to create an additional column in Access based on certain condition such as if sex = male, than cost + 500? How could I write that in my VBA? Thanks!
  4. H

    How to add an additional column in query?

    Hi All, Could anyone tell me how to create an additional column in Access based on certain condition such as if sex = male, than cost + 500? How could I write that in my VBA? Thanks!
  5. H

    How to show the Sum by grouping in Report?

    Hi All, I am pretty new to the Report Function of Access. I would like to know how I could how the Total of a particular column grouped by a few categories. I tried searching it in Help and not be able to find it. Thanks a lot for your help!
Back
Top Bottom