Search results

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.

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...

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...

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...

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...

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...

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...

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...

I have a report in which I use vertical lines to separate values. However, there are data fields which need to grow, while others do not (some data fields require two lines while other only need one). Since that caused the lines to break where two rows were required, I added the code below to...

So I need to return the last day of a field called [Period]. If the value of the field is #05/14/2018#, I want to return #05/31/2018#. I created the following public function; Public Function LastDayOfMonth(D As Date) As Date Dim LDOM As Date Dim NM As Date NM = DateAdd("m"...

I need to limit my query/report output to only include a 90-day date range of a field I call “Post-Date”. The ending date for that range is the last day of the month of a field I call “Period”. The first day of the date range is 90 days earlier then that date. The function below successfully...

Hello All ... just introducing myself. I am working in Philadelphia at an academic Health Center. I have been using MS Access for awhile now, but am just recently delving into VBA. Unfortunately, I do not have any colleagues in my immediate work environment who can help by mentoring me in...