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
Using a parameter in a report by Paul Kraemer
Hi, I am using Access 2007. I have created a report where the RecordSource is set to something like the following: SELECT MyTable.Tag1, MyTable.Tag2 FROM...
May 24th, 2010 04:40 PM
by Duane Hookom Go to last post
2 996
Write Name of Report Query in Report Footer by Steve Stad
Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer.
May 24th, 2010 03:59 PM
by Steve Stad Go to last post
2 853
Sorting/Grouping ... Show a month if Zero (Access 2007) by SCS
I've created a fairly simple database. Mostly it has an order date, and the number of items ordered. I've created a report that will show order counts by...
May 24th, 2010 03:45 PM
by Marshall Barton Go to last post
1 778
email recipient address shows twice by aussiebob
I have managed to use sendobject to email a report as an attachement and populate the "email to" address however on the email to address shows twice- once as...
May 24th, 2010 01:04 PM
by aussiebob Go to last post
2 751
Bound Chart in Report Issues - Access 2007 by Andre[_5_]
I have a simple table, containing a count, a status and an agent name. I created a simple report, with a header by agent name. The idea is that the report...
May 24th, 2010 12:33 PM
by Mark Andrews[_4_] Go to last post
3 833
new crosstab option? by auujxa2 via AccessMonster.com
I have a table that displays results horizontal, that needs to be verticle, so it shows up on a report in one page, instead of one record per...
May 24th, 2010 05:21 AM
by Duane Hookom[_4_] Go to last post
2 952
Grouped/Sorted Report by Month by SCS
I have a fairly simple access database. I've created a report grouped by Category and Month... with a total per month. My problem is that the months...
May 24th, 2010 04:09 AM
by Marshall Barton Go to last post
1 736
Hide Sub Report(s) when records are null by Bruce
I am running Access 2007 sp2 MSO. I have a report that has three (3) sub reports. There are times when not all three sub reports have values to display. Is...
May 24th, 2010 03:37 AM
by Bruce Go to last post
0 788
Updating Form==Query==Report by Dan
I have a date form. It has 2 text boxes that pass starting and ending dates to a query to pull appts from that time period. If the report is left open and...
May 23rd, 2010 11:08 PM
by Marshall Barton Go to last post
2 797
Auto-generated Report by Timothy Millar
I have a form with a command button. If the EndUser clicks the button a report is generated and saved to the hard drive and the EndUser moves to the next...
May 23rd, 2010 12:46 AM
by Steve[_77_] Go to last post
1 739
linking queries to create a report by Susan
is it possible to link queries to create a report? if so how would i do this?
May 22nd, 2010 07:45 PM
by Larry Linson Go to last post
2 668
editing/deleting by Susan
i have created my report that represents an income statement but i do not know how to delete certain fields that do not belong in the income statement, i do...
May 22nd, 2010 06:09 PM
by Duane Hookom Go to last post
1 758
how to create a report that represents an income statement by Susan
i would like to know how to create a report that represents an income statement. i've done my query but got stuck creating the report. i'm asked to: list...
May 21st, 2010 05:15 PM
by Duane Hookom Go to last post
1 679
Parameter Prompt Annoyingly Appears (sometimes) by JeffP->
I have a form that I set the SQL query to either if len(sParam) = 0 then sSQL = "Year=2007" Works fine I get all records for that year If len(sParam) 0...
May 21st, 2010 01:14 PM
by Marshall Barton Go to last post
5 890
Report Won't Print by Frank Wagner
I have two reports that I have created using Access2000. One will print, and nothing happens when I click print on the other report. I've checked the...
(Multi-page thread 1 2)
May 21st, 2010 01:00 AM
by Duane Hookom[_4_] Go to last post
13 1,288
Report - Don't print the page footer on the last page by Dwade
When I print a report I don't want the page footer to print at the end of the report I only want the report footer to print The page header must print on...
May 20th, 2010 11:56 PM
by Dwade Go to last post
9 761
how to I design an Access report for headed paper on page 1 only? by Liz232
I have a report that I am designing to work as an invoice using company headed paper. Therefore I wish to be able to have wider 'blank' footers for the...
May 20th, 2010 10:25 PM
by Chris Go to last post
1 722
Hiding Group Footer based on condition by Macker
Can anyone tell me how to hide Group Footer based on a condition? Below is an example of output. I want to display subtotal only if number of projects are...
May 20th, 2010 05:19 PM
by Marshall Barton Go to last post
1 740
Reminder - Microsoft Responds to the Evolution of Community by [email protected]
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...
May 20th, 2010 04:13 PM
by [email protected] Go to last post
0 736
Final results by Charno
I'm a bit new to Access and trying to find my way around it. I've created my tables and forms etc and i'm now trying to create reports from the data that is...
May 20th, 2010 02:21 PM
by John Spencer Go to last post
2 742
Post New Thread


Display Options
Showing threads 81 to 100 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:17 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.