A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 4 of 4
Search took 0.03 seconds.
Search: Posts made by: David McCormack[_2_]
Forum: Setting Up & Running Reports June 7th, 2010, 06:52 AM Posted to microsoft.public.access.reports
Replies: 10
Views: 3,531
conditional numeric formatting of field output on report

Marshall,

Thank you for the help. It didn't help out completely, but it got me in the
right direction and I was able to get my report to work properly.

"Marshall Barton" wrote:

David McCormack...
Forum: Setting Up & Running Reports June 6th, 2010, 07:52 PM Posted to microsoft.public.access.reports
Replies: 10
Views: 3,531
conditional numeric formatting of field output on report

I have tried this but I keep getting an error. This is what I have:

=IIf([Operation]=2,Format([May], "##0.0"),Format([May], "##0.0%"))

I have a field that if the object [Operation] is equals to...
Forum: Setting Up & Running Reports March 10th, 2010, 06:35 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 290
Get fiscal year to show in a report

Jeff,

I guess I should have titled this differently. It should have said "Get a
report to sort/group by a fiscal year."

"David McCormack" wrote:

Jeff,

I'm not trying to convert the year...
Forum: Setting Up & Running Reports March 10th, 2010, 06:20 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 290
Get fiscal year to show in a report

Jeff,

I'm not trying to convert the year information per sai. I am trying to show
a year-to-date report that will summerize the information by the fiscal year
which runs 11/01 through 10/31. The...
Showing results 1 to 4 of 4

 
Forum Jump

All times are GMT +1. The time now is 04:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.