ContributionsMost RecentMost LikesSolutionsRe: Button/Link on Dashboard to Second FormThank you Adam. Works perfectly ------------------------------ Nigel Ho ------------------------------ Button/Link on Dashboard to Second FormI have a form linked with a button on the dashboard. I have now created a second form which I would like to link to the dashboard as well for the obvious different action. How can I do that? ------------------------------ Nigel Ho ------------------------------ SolvedAuto Generate Unique Sequential Project Code by SectorsI have a list of unique projects with actual project names. Each project belongs to a Sector (Retail, Commercial, Office, etc). In one of our report, the intention is to provide a report info without giving away the actual project name. I would like to have a functionality that automatically generate a Generic Project Name based on the Sector it is in. For example: Actual project names Retail Shop John Commercial Tower Apple Commercial Google Office Project Jane Generic Project names Retail 0001 Commercial 0001 Commercial 0002 Office 0001 The above fields is in a table called Projects The sector names are now in a dropdown list field on a separate table on its own called Sectors I have created a 2 fields - Project & Project_Generic but not sure how to move forward. Any help is much appreciated. ------------------------------ Nigel ------------------------------ Re: Remove totals column from summary reportI am looking for the same resolution, I have tried what Aaron has suggested but doesn't seem to work. Anyone else have any luck? ------------------------------ Nigel Ho ------------------------------ Re: Sorting Chart SeriesThanks Mark. That fixed it. ------------------------------ Nigel Ho ------------------------------ Re: Sorting Chart SeriesHi Mark, Yes. The projects are not sorting alphabetically. Yes. The project name field is from a multiple choice list. ------------------------------ Nigel Ho ------------------------------ Sorting Chart SeriesHelo I have preparing a Bar Chart and have a series for Project A, B, C, D & E With this bar chart, I am summarizing the 3 Sum Values 01 Initial Cost 02 Current Cost 03 Forecast End Cost So I am expecting a bar chart that have 5 sets of 3 bar values starting from Project A from the left and ends with Project E on the right. However, I get a sequence of Project A, C, D, E & B I have tried various ways to change the sort order but can't seem to find a solution. Appreciate some help. Thanks ------------------------------ Nigel Ho ------------------------------ Solved