Setting Up & Running Reports - Page 1045

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
group sections by year by KGates I have built a report based on a query that is sorted by a case number. There is also a date field. I'd like to get the report to group the cases by year. ...	October 13th, 2005 01:12 AM by Duane Hookom	4	100
Calculation in a report by GAIL HORVATH I am trying to write a function in a report where it will count the number of records where a one field is equal to a particular value. The report is based on...	October 13th, 2005 01:08 AM by GAIL HORVATH	5	95
template file by agodfried I would like to use sendobject to email a report using html format. However, checkboxes on the report do not show propertly. Would a template file resolve...	October 13th, 2005 12:12 AM by agodfried	0	62
Subtotals in reports by wizard_chef I have a problem that is probably due to a poorly designed set of tables, but now I have a rather large set of data in the database that I do not wish to...	October 12th, 2005 11:57 PM by wizard_chef	2	78
Need help with expression by Jessica Murray I hope I'm posting this question in the right area. I've created a report from a query that shows the number of jobs per person within a date range. My boss...	October 12th, 2005 10:42 PM by Jessica Murray	4	93
calculating percent of totals by JR Hester USing Access 2000. L:ogical field in table named "TrxRegistered" Use dteh report wizard to create a summary report showing number of participants for a series...	October 12th, 2005 10:39 PM by JR Hester	1	119
How do I implement word wrap in an Access report field? by DAPPER Is it possible to implement word wrap in any field in an Access database report?	October 12th, 2005 09:31 PM by Rick Brandt	1	131
Alias by rob p I have a query with a check box. From a previous posting I can use this code: (from fredg) Like IIf(IsNull(),"*",) for a parameter that determines what will...	October 12th, 2005 07:43 PM by Duane Hookom	1	58
IIf A=1 then B=Visible by aaearhart this is what i have: myText (unbound) Control Source: =Sum(DateDiff("d",,)) myCheckBox (unbound) Control Source: Show days? when the report loads, you are...	October 12th, 2005 07:28 PM by aaearhart	5	96
Where is my FormatSNP in my mail ? by Tschuß Hi, I have the following code in my report: DoCmd.SendObject acSendReport, "CEM_Report", acFormatSNP, But, in my mail, the attached file is not...	October 12th, 2005 07:23 PM by Tschuß	3	82
Reports not sourcing data from Forms.-URGENT! by BGchiq Can someone help me, my reports are not printing the data from the forms, when I print preview them they are all blank, before they were all showing up on the...	October 12th, 2005 06:58 PM by Duane Hookom	8	86
Can (should) an auto number be set up on a invoice (report)? by Robert Robinson I am using the reports module to create an invoice. I want the report to generate a unique invoice number. Can this be accoumplished using an unbound text box,...	October 12th, 2005 06:51 PM by Steve Schapel	5	281
Converting numbers to ANSI characters in access by sjkrause In excel, numbers can be easily converted to ANSI characters using the CHAR(#) function. Is there an equivalent function in access, or some means of producing...	October 12th, 2005 06:35 PM by sjkrause	2	66
dsum issue by Bdavis Hello, I have a control on a form with the following formula =DSum("","qry_RCTrack"," = ????") Obviously the ???? is the part I can't figure out. I'm...	October 12th, 2005 06:33 PM by Duane Hookom	4	83
sum a group of fields in the report by Ruzhena I am having a problem with totalling the "Extended Price" field by Invoice in the Report. The total should appear only at the end of the group of products for...	October 12th, 2005 05:23 PM by Duane Hookom	1	52
Preview Multiple Reports by Mike I have a form with report parameters in combo boxes and a Print Preview command button. I use DoCmd.OpenReport stDocName, acPreview to run the report and...	October 12th, 2005 05:12 PM by Mike	5	75
Running code in a SubForm on the main report by Gary Robinson Hi All I have a system that order new street signs, I have a form which I use throughout the system which, draws the sign, depending on the values stored in a...	October 12th, 2005 04:50 PM by Gary Robinson	3	65
advice on better report design - opening/closing balance by Sag73 Hello Group, I have a table which contains transactions (in and out) of a stock item. The objective was to create a report based on a user specified period...	October 12th, 2005 04:41 PM by Marshall Barton	1	99
Conditional formats lost on report export to RTF by JVP Access 2000 introduced conditional formatting in reports. There work great in preview, but are lost when the report is exported to RTF. I find no updates or...	October 12th, 2005 04:30 PM by naiveprogrammer	1	80
My report is not pulling the data from my forms, can you help me? by BGchiq Hello, my reports are not printing the data from my forms, it was before when I previewed it, but when I moved around the fields to make the report...	October 12th, 2005 04:19 PM by Duane Hookom	1	94

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