X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Expression Showing Decimal Place, 11    
post Aug 19 2016, 04:21 PM

Posts: 696
Joined: 5-November 07

I have a number parameter that is asking for a year. I run the report and it gives me all the data for entered year. I then used the parameter value in a formula so I can get a month summary crosstab report. It seems to be working except the display is showing as 2,016.001.00 for January 2016, 2,016.002.00 for February 2016 etc. I just want the 2016-1 and 2016-2 to display without decimals and commas. How do I do that? Here is my formula.
({?Application Start Year})&month({credit_application.data_entry_start})
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    28th January 2020 - 07:09 PM