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
IIf function help please by [email protected]
Hi I have a Totals column in a report that adds a Points and Bonus Points field using =Nz(,0)+Nz(,0) I would like to modify this so that if is empty (Null...
April 17th, 2010 02:37 PM
by John Spencer Go to last post
3 278
Formatting currency within a report text box expression by Parish Pete[_2_]
I'm trying to create a mail merge letter from a 2007 ACCB database using a report (Word can't cope with the filter) To keep the text flowing to allow for...
April 17th, 2010 02:33 PM
by Peter Hibbs Go to last post
1 283
Access 2007 Reporting Versus Crystal Reports by Brad
Recently the topic of Crystal Reports was brought up. We are a small firm with a small IT budget. Our data lives in SQL Server, Access 2007, Excel, and in a...
April 17th, 2010 02:53 AM
by Brad Go to last post
2 395
2 column report by warui boy
I would like to create a 2 column report with 3 fields each (phone list with extensions). I need to have the records wrap to the the second set of fields,...
April 17th, 2010 01:13 AM
by Larry Linson Go to last post
2 202
Report Sum question by [email protected]
Hi all I have a report that shows output from a League Table Most years have just Played/Won/Drawn/Lost/For/Against/Points format However, a handful of...
April 17th, 2010 12:26 AM
by [email protected] Go to last post
6 192
Access Report question by Keith K[_4_]
I have a data set I am building regarding our dealerships and their service capacity. There are 15 different items or so per store and 5 years of data. For...
April 16th, 2010 10:34 PM
by Duane Hookom Go to last post
1 242
Set report criteria in code? by Fredrated
Is it possible to set a reports criteria in code? I am trying to use Stephen Lebans report-to-pdf tool, which uses the report as a parameter. I need to...
April 16th, 2010 09:56 PM
by Marshall Barton Go to last post
2 205
Masking a field in Report only by messingerjc
One of the fields in my main table has a social security number. I have the formatting correctly showing the dashes. I have a few different reports, some...
April 16th, 2010 09:25 PM
by messingerjc Go to last post
2 200
Suppressing undesired lines by Richard[_41_]
I am developing a report for my supervisor -- he doesn't want to see individual detail lines under $1,000, but want them included in the grand total. How do I...
April 16th, 2010 07:02 PM
by John Spencer Go to last post
1 203
Complex Query not working on report by Broken Coder
I recently started using 07 on a fe/be db created in 03. The query below worked fine in 03 but now gives me the "enter parameter value" box asking for...
April 16th, 2010 05:23 PM
by Sylvain Lafontaine[_2_] Go to last post
3 214
Creating an a report from an indivual record in a table by SamMexico via AccessMonster.com
Hi all, I've been searching for an answer to my question for a while and have got more and more confused as to the best way to approach it...I am a...
April 16th, 2010 03:22 PM
by SamMexico via AccessMonster.com Go to last post
3 266
How do I calculate the # of business days between two dates? by Judy
I know absolutely nothing about coding. Trying to use calculations in a report or query to accomplish this. Everything else I have found seems to include...
April 16th, 2010 02:10 PM
by Mark Andrews[_4_] Go to last post
1 251
Accessing SQL Server Table-Valued Function from Access front-end by Arvi Laanemets
Hi Is subject possible? From SQL Server, I can call the function as Select * From dbo.udf_MyFunction(Parameter1, Parameter2, ...) From Access front-end, I...
April 16th, 2010 07:13 AM
by Sylvain Lafontaine[_2_] Go to last post
1 303
Crosstab Report's subreport by Joseph
I have a report based on the following code: Private Sub Report_Open(Cancel As Integer) On Error GoTo Err_Report_Open Dim dStart, DayOne, DayTwo,...
April 16th, 2010 04:42 AM
by Duane Hookom[_4_] Go to last post
1 254
Formatting in columns by Bird Byte
Hello. I have a report that lists name and phone extension across multiple columns in a report. Is it possible to insert dots between the name and the...
April 15th, 2010 11:55 PM
by Marshall Barton Go to last post
1 195
format single cell by Robin
Hi. I have created a crosstab report and I would like to color some cells a certain color and others a different color. I can color a whole row or a column...
April 15th, 2010 10:23 PM
by Faith &hope Go to last post
2 271
Assigning a criteria by szag via AccessMonster.com
I know am looking for the best way to accomplish the following: I often have situations where I need to interchange a criteria for the same report. For...
(Multi-page thread 1 2)
April 15th, 2010 10:18 PM
by szag via AccessMonster.com Go to last post
12 350
Change the form size when it runs? by GWB
I'm trying to have the form appear at 150% when it runs - so I dont have to enlarge it to seeit..... how is this done? Thanks!
April 15th, 2010 09:57 PM
by GWB Go to last post
2 163
counting records shown in a report by Becky
greetings to all I have a report bound to a query called qAttendance. The report has its Filter property set to limit the records showing in the Detail...
April 15th, 2010 09:02 PM
by glj011848 Go to last post
3 222
DateDiff and Count/Sum by caro
I am trying to count records where the scheduled date is greater than the current date. All Dates (past visits and scheduled visits) are listed in the Date...
April 15th, 2010 06:53 PM
by Duane Hookom Go to last post
6 218
Post New Thread


Display Options
Showing threads 301 to 320 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:45 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.