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
=Count([Category] if it is equal to 'Task ID'"), how do I fix thi by Iram
Hello, I have a report with the fields "Date","Catgory","Amount" and I have grouped it by "Date" by day. For each day I need to Count the indivudual...
April 3rd, 2010 12:03 AM
by Iram Go to last post
4 470
Duplicate values added together and print only once on report by KARL DEWEY
Use this -- SELECT , , , , , Sum( * ) AS Total FROM YourTable GROUP BY , , , , ; -- Build a little, test a little. "Mommybear" wrote:
April 2nd, 2010 09:16 PM
by KARL DEWEY Go to last post
0 265
Running reports for a date range... by TheDrescher
Karl, Thanks for the tips, The code I have for the report button now is: Private Sub EmpButton_Click() On Error GoTo Err_EmpButton_Click Dim stDocName As...
April 2nd, 2010 06:13 PM
by TheDrescher Go to last post
3 335
Sub-report sorting problem by [email protected]
Hi I created a sub-report to include some notes from a notes table into my League report It uses the following: SELECT DISTINCTROW tblnotes.ID,...
April 2nd, 2010 05:45 PM
by [email protected] Go to last post
2 286
Charts/graphs on Access forms and reports by M Skabialka
I have been given a project where I have to create a chart on a form and duplicate it on a report. There are three dates that are sequential that need to be...
April 2nd, 2010 05:22 PM
by Duane Hookom[_4_] Go to last post
3 469
Displaying column history in a report by Jonathan2678
I am trying to create a report that is linked to a sharepoint (MOSS 2007 ) table. One of the fields is a append text field, and I want to be able to display...
April 2nd, 2010 02:15 PM
by Jonathan2678 Go to last post
0 307
First line of report - Upper Case by [email protected]
Hi I am using Access 2007, and have a database of League results. One report that I generate is yearly League tables. I would like to either output the top...
April 2nd, 2010 02:05 PM
by John Spencer Go to last post
4 249
Report that should show multiple image attachments only shows one. by oaksong[_2_]
I've got a table with an attachment field that I'm using to store images. I've got a report based on a query of that table plus others that works just fine...
April 1st, 2010 09:11 PM
by oaksong[_2_] Go to last post
0 212
Sum ignoring hidden duplicates by h2fcell
Hello, I’m using Access 2007 to create a report that list Hotel reservations and the names of the people in the reservation as follows: Name ...
April 1st, 2010 06:44 PM
by h2fcell Go to last post
0 227
Group Header doubling on first page by lcsmoothey
I am building a report with 3 layers of nesting and want the header of my subreports to show at the top of each page they go over. I have tried using the...
April 1st, 2010 05:29 PM
by Marshall Barton Go to last post
1 216
same report displays in 2003 but not in 2007 by m galvin
A few fields in my report display numbers up to 9,999,999.99. If I open the report in Access 2003 it displays the number. If I open the same report using...
March 31st, 2010 04:54 PM
by Duane Hookom Go to last post
2 287
filling a field in a continuous form with a field from a table by m galvin
I have a form with the fields: date, client, atty, time, billable and description. All these fields update the Time Sheet Table. I want the atty field to...
March 31st, 2010 03:00 PM
by Duane Hookom Go to last post
1 154
Zero Suppress by Peter Marshall
This is probably very simple: I have a report that displays many columns of numbers, many of which are zeroes. To make the report more readable, I would...
March 31st, 2010 02:32 PM
by Marshall Barton Go to last post
1 171
dsum on report getting #error by Alan
=DSum(""-"","Tabel1"," = " & ) Have this on my report my report fives me this CustomerNo Amount Amount2 result C00001 1000 1000 ...
March 31st, 2010 04:49 AM
by Marshall Barton Go to last post
3 193
access report by Danny Jackson
i have a combo box in a form to select 1 of 5 values and i setup list so each selection has a number value ie, 1. table 2.dessert etc. i have check boxes on...
March 30th, 2010 02:43 PM
by Marshall Barton Go to last post
1 195
How to add more that one tables or queries to report record source by TP88
How to add more that one tables or queries to report record source? In Access 2003.
March 29th, 2010 06:50 PM
by John Spencer Go to last post
6 236
Page Count Error by OldManEd
I have a 4 page report. I use the default Page Count function. It prints: Page 1 of 3 Page 2 of 3 Page 3 of 3 Page 4 of 3 How does one correct this...
March 29th, 2010 04:02 PM
by Allen Browne Go to last post
1 200
Change currency values in report. by George
Is it possible to change values in a report from Australian dollar to USD? The report is currently set up in Australian dollars and i would like to maybe use...
March 29th, 2010 06:57 AM
by Allen Browne Go to last post
1 294
Select only even or odd number records by Phillip
Hi, I have a table with among other things has on number field. I want two reports, one that select only records with even number in the number field and...
March 29th, 2010 04:59 AM
by Duane Hookom[_4_] Go to last post
3 202
Some of my info added on forms fails to show up in the report. by Comet 184
I have tried to figure out why some flows to the report but some doesn't. I assume it has something to do with the parameters in my report set up. Is...
March 29th, 2010 02:06 AM
by Gina Whipp Go to last post
1 241
Post New Thread


Display Options
Showing threads 401 to 420 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 01:42 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.