Setting Up & Running Reports - Page 958

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.

Thread / Thread Starter	Last Post	Replies	Views
How to filter a calculated field in a peport? by kai Hi, I use Access 2003. I created a report which lists customer oreders and calculates total for each customer in the footer. I would like to filter the result...	January 17th, 2006 12:28 AM by kai	4	97
Date value needed for Access report by Phil I have an Access 2003 report that needs to request a date value from the user whenever it is opened. This date value does not have to be saved in the database,...	January 16th, 2006 10:22 PM by Duane Hookom	5	112
How to input text in Report Header on runtime, not from table by bstullos I am prompting for input(the month) for the header, and it works unless the results of the query has 0 records. Then it turns into an error. Is there another...	January 16th, 2006 10:18 PM by Duane Hookom	3	105
count expression by Ray Is there a way to use the Count expression in a report so that I may be able to obtain the total number of a particular input in a column? For example, if I...	January 16th, 2006 09:11 PM by John Spencer	2	68
Multiple IIF in Query for Report by TinleyParkILGal Dear Professionals: In my table my fields a Salutation FirstName Middle Name Last Name In my report I have one field in which I want to concatenate the...	January 16th, 2006 09:06 PM by John Spencer	2	64
value not to exceed by DFDGirl I have a sum of vacation hours on a report. I do not want the "total" number of hours that I track to go over 240. How can I do this? Thank you	January 16th, 2006 09:01 PM by John Spencer	1	66
Please proofread my syntax by Odniel Please tell me what is wrong with this line: =CanShrinkLines(,Trim(),Report!WIDTH,) The following Microsoft knowledgebase article told me to create a...	January 16th, 2006 08:55 PM by BruceM	6	92
Missing data when exporting to Word by DiHo I need to permanently save a report on a weekly basis (no overwriting of previous reports) in a format other than Access. When I try to export to HTML or Word...	January 16th, 2006 08:47 PM by DiHo	1	55
Getting the Count of Record in a Group by Don How does one go about getting a count of the number of items in a group to put in the group header or group footer. (If it is possible at all!) I started...	January 16th, 2006 07:30 PM by tina	3	68
Extra Space by DS I'm having a problem printing, I'm sure it's a setting but what I don't know. It seems that whenever I add anything in a Page Footer in a report I get Extra...	January 16th, 2006 07:27 PM by DS	0	60
OnNoData System Error Msg by Sandy Hello - I put a messagebox in the Sub Report_NoData indicating no data for the selected criteria. It works great, except that after my messagebox comes...	January 16th, 2006 06:21 PM by rajeev	7	180
Cannot view or design reports, multiple databases or computers by EE in Need Having an issue just recently that is occuring on multiple databases and all machines tested so far. I open an existing database, double click my report, and...	January 16th, 2006 06:00 PM by EE in Need	1	119
Viewing N of TotalN Records by E Hello group - Using Access 2000 REPORTS I want to show: "X records of TotalX" on each page of a report (x is incremental, TotalX is all records) I got the X...	January 16th, 2006 05:47 PM by E	2	83
Help with lines by Mike Busch I would like to have vertical lines from the report header down to and part of the detail section in a report. Is this do-able with out haveing a break in the...	January 16th, 2006 05:19 PM by Rick Brandt	1	68
make a text box only appear if txtEmployee IS NOT Blank by Walter Mills I need to make a text box (txtfinal) that has an expression like this: If "txt1" 8, then subtract 8 from "txt1" and also if lstName is null then txtFinal is...	January 16th, 2006 03:46 PM by tina	1	90
too many characters in an ab box by Database User I have a field in a report of = & " " & I want to say that if there are more than 20 characters in that text box then make the point size a little smaller. I...	January 16th, 2006 01:12 PM by Ofer	1	66
Reports Blank Currency Fields by Nigel Bate I have a main report with 2 subreports, 1 for sales orders (with a Calc. totals fields) and 1 for PO's( With Clac. Totals field). These are then used to...	January 16th, 2006 12:27 PM by Nigel Bate	6	139
Mabry Barcod Control by Murp I am using the Mabry Barcod control in A2K to print a 40 page barcode report with roughly 40 barcodes on each page. As you can imagine, printing this report is...	January 16th, 2006 12:28 AM by Murp	0	66
Display fraction on specific way by Adam Jay Hi if i have fraction number like .784 and i want to display it in report as 784/100 format is there is any function can do that? Thanks	January 15th, 2006 06:17 PM by Duane Hookom	1	88
Display XXX before and after the numbers by Adam Jay Hi i am trying to disply XXX befoe and after any number in the report, examble this number 24,544.22 should appear XXXX24,544.22XXXX Is there any function...	January 15th, 2006 05:23 PM by tina	2	93

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed