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 Reverse Sort Order Last Post Replies Views
Emailing from Access by Alex
Not sure if this is correct forum Am looking to be able to set up routine to allow me to send emails from data held in Access Query - either through outlook...
October 21st, 2004 12:44 AM
by Daniel Go to last post
1 108
graph creating problem by Alex
We have a survey where all questions rated as 1, 2, 3, 4, 5. In this survey we want to calculate scores for questions as e.g. {(( answered with rating 5) x 5+...
October 17th, 2008 12:56 AM
by Alex Go to last post
2 130
Button to print several reports by Alex
Does anyone know some code to put behind a button on a form that will print, for example, rpt1, rpt2, rpt3, when a user selects a printer from the print...
September 10th, 2008 11:19 PM
by Chuck Go to last post
6 172
Print multiple reports from first printer by Alex
I am trying to write VBA on a form button on_click event that will open report1 and allow the user to choose which printer he/she would like to use. I would...
August 7th, 2008 03:15 PM
by Alex Go to last post
2 160
How to Use Expression Builder to display Query Results? by Alex
Hi, I have a report with a text box in it. I'm trying to use the Expression Builder to display the result of a query in this textbox. Let me explain:...
April 19th, 2007 04:06 AM
by Duane Hookom Go to last post
1 97
Formating decimal places in an unbound field by Alex
Hi, I have an unvound control which contains some text as well as the following code: & *100/ & " How do I restrict the calculation above to 0 places of...
November 1st, 2006 10:56 PM
by Alex Go to last post
4 138
Line value by Alex
Hi Within an Access report, i need to be able to visually display a single line chart which represents a data value out of 100 Can some kind person tell me...
October 28th, 2006 02:40 PM
by Alex Go to last post
0 76
List Box Not Populating Properly by ALEX
I am trying to create a report that displays multiple records in a list box based on a field (WO KEY) on the report. The feild is a member of the main...
October 4th, 2006 03:24 PM
by ALEX Go to last post
0 74
accumulating numbers in subreport by Alex
I have a total qty for a contract in a report. In a subreport in the detail section I have received qty by dates. How could I calculate in the subreport detail...
April 27th, 2006 05:27 PM
by Alex Go to last post
2 108
very slow report with dcount() by Alex
Hi All, I have a very slow report because I’m using dcount() for every individual item on this report. I would appreciate if somebody could advise some...
October 28th, 2008 01:59 AM
by Duane Hookom Go to last post
6 91
chart data table formatted incorrectly by Alex
My chart data table formats as general regardless of how I format the field in my query. Does anyone know how I can get my data table format to...
January 23rd, 2006 11:04 PM
by Alex Go to last post
0 111
Showing Only Labels in the First Column of a Report by Alex
I've used the instructions in article Q208491 to set up a multi-column report with lables in only the first column. I created disassociated labels and text...
September 13th, 2005 03:03 PM
by Alex Go to last post
2 103
Sum Workdays by Alex
I have a date field in my report and users will enter a beginning date and ending date as the report parameter. I'm showing all records by date. How can I...
May 26th, 2005 01:01 PM
by SA Go to last post
3 203
how to identify what value has a max occurence in a report/query by Alex
I have a simple report with fields such as Day, Product, Thrown Out Qty, and Reason. For some period the same reason (e.g. cutt off) can occure many...
May 6th, 2005 10:50 PM
by Alex Go to last post
1 127
calculated field doesn't show the correct data by Alex
I have 3 fields in a query and in a report: Aug, FAug, and AugP. In the query AugP is being calculated as follows: =IIf(nz()0,nz()/nz(),IIf(nz()0,1,0)). So,...
November 23rd, 2004 07:17 PM
by Alex Go to last post
3 128
Convert Number to Text! by Alex
Dear All, I have a Query in which you can find a columns with numbers, from 30 to 100, I want these numbers to be converted in to letters (A, B, C, D, E,...
February 3rd, 2005 04:27 PM
by Tim Go to last post
5 152
How Do I add a field on a Report by Alex access
Hello, I'm trying to add different amounts from one field (Bid amount) using a text box at the reports footer. Per example: Project ...
June 13th, 2008 07:01 PM
by Stockwell43 Go to last post
3 128
How to create such a specific report? by Alex B.
Hello! I need to get data from a table with a query like this: SELECT Sum(R) FROM MyTable WHERE Field1=X and Field2 LIKE Y; X is a field of another table...
September 20th, 2006 12:06 PM
by Alex B. Go to last post
0 60
Use parameter querys and reports by Alex Brown
I have a table which has the list of students in a school. I have another index table with id numbers and the name for each academic department in the school....
March 28th, 2005 10:08 PM
by Alex Brown Go to last post
0 111
DLookUp Error is frustrating!!! by Alex B[_2_]
I have tried many different syntax's (both with and without criteria) to get the DLookUp function to work, but I always get an #Error. I am trying to create...
October 1st, 2008 01:27 PM
by Alex B[_2_] Go to last post
0 77
Post New Thread


Display Options
Showing threads 1001 to 1020 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:49 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.