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 » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting Up & Running Reports Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Strange Month and Format results by tkosel
I have a report where I need to change a label caption depending on conditions. I have done this in the past. However, I am getting strange results and...
January 2nd, 2010 06:51 PM
by fredg Go to last post
2 169
How to Change Digits Into Words In Report by malik via AccessMonster.com
Hello. I have a report in which i have a TxtBox in Group Footer which is having the Sum of a field. Now, how can i Convert the sum into Words in a TxtBox in...
January 1st, 2010 09:40 PM
by malik via AccessMonster.com Go to last post
3 143
Deleting part of a string by John Harrington
I have a field in a report that is a comma delimited list. What I'd like is a function that will delete all after the first comma, so that I get the first...
January 1st, 2010 03:08 PM
by John Spencer Go to last post
2 117
How do I write the print date on data row? by Dennis
Hi, I need to run a report once a month. When I run that report, I select all unprinted record / row and print them on the report. When I print the record...
January 1st, 2010 05:47 AM
by Dennis Go to last post
4 136
Alternate rows with bold font by *Glen*[_2_]
Can anyone tell me how to make the rows in my detail section of the report alternate between bold font and normal font to make the report easier to read? ...
(Multi-page thread 1 2 3)
December 31st, 2009 10:11 PM
by Clifford Bass via AccessMonster.com Go to last post
27 976
Subtotals in Group Footer by Robbie Doo
I have 2 grouppings: Reason and Reason Category. Each Reason has it's own group of Categories, where I use the following to code to count: =IIf(=26 Or =27 Or...
December 31st, 2009 07:06 PM
by Duane Hookom Go to last post
3 127
Can't change height of group header by ScottIA
There is a report I run from a database that will not allow me to change the group header height setting. It is stuck at 22", and whether I try to reduce...
December 31st, 2009 02:56 AM
by Allen Browne Go to last post
4 137
Password protected form by Lyne Savage[_2_]
I have Access 2003. Can I put a password on a form, or in a Macro? I want to limit those who have access to certain forms through command buttons.
December 30th, 2009 10:31 PM
by Dale Fye Go to last post
2 126
Removing Empty Line by Sue Compelling
Hi I was given the following code (via this forum) to remove the first empty line if my client doesn't have a home telephone #. I works brilliantly - but...
December 30th, 2009 10:15 PM
by Sue Compelling Go to last post
5 146
How can I change the recordsource of a report in code? by Andrew Soep
I have a report that I want to be able to control which recordsource it uses in code. I tried setting Me.RecordSource = MySQL statement in the OnOpen event,...
December 30th, 2009 10:11 PM
by Duane Hookom Go to last post
2 168
Grand Total for a calculated column - Access 2007 by PanoramaB
I've developed a report with a variety of calculated columns. The last column (total)is the sum of a column that had a value and another column that...
December 30th, 2009 07:28 PM
by Marshall Barton Go to last post
1 138
Report runs, but table it references doesn't exist? by Steve Woodward
I've been updating an Access application to reference the main data table via ODBC and a MySQL. All the basic stuff works, but one of the reports has me...
December 30th, 2009 04:59 PM
by Dale Fye Go to last post
2 169
data type mismatch by Mary
I am working on a report that should return only current members. In the CommitmentDate table, each time a member renews, their renewal date is entered along...
December 30th, 2009 04:46 PM
by Duane Hookom Go to last post
4 170
Help with approach to report by Dennis
Hi, The charity I work for received money from different government grants. We have to submit reports government agencies using their formats. The point of...
December 30th, 2009 07:16 AM
by Dennis Go to last post
5 117
Accessing Subreports Group Section Totals in Parent Report Header by David
Hi, I know how to grab report totals from a subreport. What I wonder is: Is there a way to grab group section totals and use in the main report. I know...
December 30th, 2009 02:00 AM
by Allen Browne Go to last post
1 117
IIf - Sum Problem by helpmeplease
I have an employee database which tracks training. I have a table with basic employee information and a seperate table to hold all trainings with dates...
December 29th, 2009 08:40 PM
by KARL DEWEY Go to last post
1 95
concatenate problem by Mary
Is it possible to base a concatenation for address labels off a query? A couple years ago you really helped me fix our address labels with concatenation, and...
December 29th, 2009 07:13 PM
by Duane Hookom Go to last post
3 124
fake checkbox based off lookup column by Mary
Hello, For our Holiday Card list, I ditched our checkboxes and created a lookup column which shows each member who requested a particular contractor receive...
December 29th, 2009 05:55 PM
by Mary Go to last post
2 145
subtotal and grandtotal like items in a report by granola911 via AccessMonster.com
Hi, thanks in advance for any help... I'm just getting into Access in a real way so forgive if this is remedial. I am building an invoice. I group my line...
December 29th, 2009 05:16 PM
by Duane Hookom Go to last post
3 117
total repeating subreport by granola911 via AccessMonster.com
Hi, thanks in advance for any help... I have main / sub report setup to produce and invoice. the main form provides the "project detail" for an...
December 28th, 2009 10:42 PM
by granola911 via AccessMonster.com Go to last post
5 125
Post New Thread


Display Options
Showing threads 1041 to 1060 of 28846
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:40 AM.


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