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 Replies Reverse Sort Order Views
Calculating an average when total is 24 hour by Whitney
I'm trying to calculating an averge handle time using total number of processed emails divided by the total handle time. However, since the time could be...
December 10th, 2007 05:48 PM
by Whitney Go to last post
7 106
Troubles with TextBox TextProperty by CristianTCDM
Hello, I want to display a certain text in an unbound TextBox on a Report and I use an EventProcedure like this : Private Sub Report_Open(Cancel As...
January 13th, 2008 10:29 AM
by Allen Browne Go to last post
7 203
Set filter in subreport by DocBrown
I have a report that has a group section. In the group header section I have a subreport where I want to generate cumulative data of the records that have...
January 19th, 2008 05:13 AM
by Allen Browne Go to last post
7 141
Report / subreport Question by TotallyConfused
I need help in in how make this work. I have a main report that lists a practice group and pts. At the end of this report I need to add an informational...
January 18th, 2008 07:18 PM
by Golfinray Go to last post
7 91
Help Need for Sales Comparison Report by Terry
I have a table of daily sales figures. Fields a WE (Numberic for Week Number) Date (Date) CashSales (Currency) ChargeSales (Currency) Credits...
January 28th, 2008 10:50 PM
by Duane Hookom Go to last post
7 130
put more than 255 field on report from two tables by billy_pit
Hi, My project is in MS Access 2002. In that I want to generate Report which contain fields 258.I can put 255 fields but how can i add more 3 fields. when i...
February 1st, 2008 05:07 PM
by billy_pit Go to last post
7 116
IIF Divide by Chuck
I have a report and i'm trying to divide the by 12 if the equals "Annual". If is not Annual, then it should just use value. The is a currency field and...
February 3rd, 2008 12:16 AM
by Allen Browne Go to last post
7 70
How do I calculate checked boxes in a report or query? by leona
I have created a table and a form with yes/no checked boxes, now I'd like to make a report or a query and in this I'd like to calculate how much was done...
February 6th, 2008 05:15 PM
by leona Go to last post
7 68
Passing Qry as part of Rpt DoCmd.OpenReport by JeffP->
If the selected manufacturer = "_All" first value in list, then my query sQry = "Year = " & ddlYear.Value else: sQry = "Year = & ddlYear.Value & " and...
February 4th, 2008 09:12 PM
by JeffP-> Go to last post
7 80
Page numbering in footers (Page # of #) by EA
I have a monthly productivity report that I print for a list of staff members and the report content is fine. However, some employees have multiple pages and...
January 16th, 2008 12:20 AM
by Sarah Go to last post
7 210
Conditional Formatting - Make Each Month's Results a different col by Richard Horne
I have a report that lists various orders for the last few months - with some as far back as a couple of years. I want to format the report so that each...
January 11th, 2008 09:50 PM
by Pat Hartman Go to last post
7 154
IIf then by JohnLute
I have an unbound text box in a report where I want to do a simple calculation. IIf has data then / IIf has data then / I can't seem to get the syntax...
December 12th, 2007 12:10 PM
by BruceM[_2_] Go to last post
7 120
Access 2003 report by Sister Jo
I am trying to create a report with 4 records on a page. Each record is 4.5' wide and 4" long. I can set it up in design and everything fits, but when I go...
December 14th, 2007 03:57 AM
by Sister Jo[_2_] Go to last post
7 89
Parameters keep repeating by Georgie047
I have created a graph report . When I ask for the report from the switchboard, I have to enter the date parameter associated with the query more than once....
January 1st, 2008 04:43 AM
by Duane Hookom Go to last post
7 180
Access 2007 Report Failure by jneseth
Our orginization is slowly changing over to office 2007, and with that an Access application that was completed in Access 2003. Now, now of the reports will...
January 30th, 2008 11:23 PM
by Julie Walraven Go to last post
7 125
Access by xeoimom
How do I highlight a date if it falls on a weekend or holiday?
December 19th, 2007 09:47 PM
by Marshall Barton Go to last post
7 87
Converting Access to Website - ASP by Jasmine
Could anyone recommend an excellent 3rd party software vendor that specialize in converting Msaccess program into ASP . I have a working Msaccess application...
December 20th, 2007 01:07 AM
by Albert D. Kallal Go to last post
7 90
How can I suppress #Error message by Ro477
I have a report in which there is a text box joining two names into one string. When the names are nothing, the text box shows #Error in the report. How can...
December 26th, 2007 05:41 PM
by Ro477 Go to last post
7 212
If Null - Display Text by SarahJ
I have a report that tracks the dates certain events happen. i.e. Date Request received Date sent out Approval date etc... How do I get the report to display...
January 3rd, 2008 01:08 PM
by John Spencer Go to last post
7 105
Set Control value on a form by MeSteve
What is the syntax to set the value of control on a form from VBA?
February 8th, 2008 01:48 AM
by Duane Hookom Go to last post
7 115
Post New Thread


Display Options
Showing threads 2021 to 2040 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 09:41 PM.


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