Search results

Thanks all - looks like I'll use the global search & replace each time I add to the sheet. I was hoping to enter a custom number (currency) format to display null values as $0.00, but can't seem to work that out.

Is there a way to return a value of $0 in a pivot table for fields that have no dollar value. I'm spending a lot of time filtering and adding $0 to null values.

Thanks so much - that did the trick!

In Excel I have 2 pivot tables & 2 charts. Each pivot & chart set is sourced from one of two different data sources (charges & payments). I've create two other tables which contain the unique data shared by both of these tables (enterprise & financial division). I created all the necessary...

Thanks DBGuy .... very helpful. I figured the code was parked in the wrong place. I appreciate your help - and patience!

Hello All, I have a field on a report which I only want to display if the value is greater than zero. I tried the following code and parked it in the Report OnOpen Event. The error this codes generates is; "You entered an expression that has no value" Here's the code ..... Private Sub...

When I run the base expression, without trying to trap errors, certain records (where Charges = 0) will return the following error; #Num! Here is the base expression [PAYMENTS]/([CHARGES]-[CONTRACTUALS]) What I want the error expression to do is replace the #Num! with a 0.

I was actually looking for some suggestions on how to resolve the expression. But thank you for the advice on tagging future posts - I will definitely utilize tags going forward. Again .... any help on resolving the expression is greatly appreciated!;)

Hello All - I have an expression in a query in which I need to layer in an "If Error" clause. I tried the following, but received the error message; "The expression you entered has a function containing the wrong number of arguments" Here's the expression I entered...

He did make it a trusted site - and all the other macros are working as expected.

I have a list box which contains division names. I have that list connected to 4 charts, so that when I select a specific division, all 4 charts display the data for that division. It works exactly as I expect it to. However, when I handed the file off to my boss (also using Excel 2016) when...

Thanks DBguy - exactly what I needed. Now that I see this expression I feel pretty dumb - I should have been able to work this one out. I guess I was just over-complicating things by thinking I need one DateAdd nessted into another DateAdd. Again - your assistance is so, so VALUABLE, and I...

I'm using the follow expression as a query criteria to return the current fiscal year (July-June) value in the following text format; "FY 2020"; "FY " & Format(DateAdd("m",6,[Enter Date]),"yyyy") I now need to return the value for the prior fiscal year. So I thought I could wrap the above...

Ok, so one more question. I now need to return the exact same value - but for the previous year?

Thank you, thank you, thank you! Worked like a charm!:)

No, the user enters a whole date; 6/1/2018 - in which case I need the expression to return "FY 2018" If the user enters 10/1/2016 the expression needs to return "FY 2017"

I have a data field named “Fiscal Year” which stores values in the following text format; FY 2018. Our fiscal year period is from July thru June – with the YEAR portion of “FY 2018” being the fiscal year ending YEAR. For instance, the date of October 2019 is part of FY 2020. Here’s my...

Hey Thanks So Much to both of you!! The DateSerial expression worked perfectly. Much appreciated

I have a financial reporting database which produces reports on a fiscal year basis. Our fiscal year is from June thru July. We completed our 1st fiscal year at the end of June ’19 and began our 2nd fiscal year on July 1st. Throughout the first fiscal year, my query calculated FYTD values by...

Hello All, I have an Access report which contains a grouping level for the following field: Financial Division. The grouping includes both a header & footer section. I've selected blue for the background color for both. When I view the report in print-preview mode, the colors I've selected...