Reports
in [Access]
|
Reporting Out Two Names w/Phone # from the Same Table I'm putting together a service report that will include two names with phone numbers for contacts at the customer's site. Service records are stored in a ServiceReport table, and contacts are stored in a separate table, which feeds the combo box on the input form, filtered by the customer name (there's a lot o... 30 Jun 2008 22:00
Textbox - Wrap text onto second line for long fields Hi, I have a (Access 2000) report that has a textbox in the group footer section. I have a formula in this textbox that concatenates two string fields. Sometimes (but not very often), the length of these two string fields is long enough that the concatenated text does not completely fit in the text box. I... 1 Jul 2008 13:22
Count detail only if it's different than other details in a group Hello, I am creating a report that keeps track of training sessions per application (for ex. the application is "Access", and the training session is called "Creating Reports"). I am grouping the report by application name, and in the details of each group I am displaying the name of the training sessions a... 30 Jun 2008 15:49
Opening reports prompts for parameter twice Hi there: I have a little dilemia. I have a crosstab query that feeds my report. I have declared my parameters in the crosstab query. This works great. I can run the query and I am only prompted once for the parameters. I have a macro that OpensReport from a button on my form. When it runs the macro and... 30 Jun 2008 15:49
What is the difference with these 2 expressions? I am trying to unravel a report that someone has created (and since left) and am getting an error in a calculated control. In one control there is this expression Round([txtprevqtrtotal8],0) and in another is this Round(Nz([txtprevqtrtotal9],0),0) The first one works ok but the second one shows #Error I'... 30 Jun 2008 14:47
Date comes out wrong in England Some of the users that will be using my program are in London. When they run my reports the dates come out in European format d/m/y. Also, I think that the reports come out wrong by putting information in the wrong place (month) on the reports. In London their version of Access is 2000, and I am using 2000 file for... 2 Jul 2008 14:59
Memo field does not grow - tried usual solutions I have a report with a memo field that does not grow. I have checked the usual - no grouping or sorting on the field, no calculations, etc. The query used by the report shows the field in its entirety. The other unusual part is that there are other memo fields that are growing, but this one is not. I haven'... 30 Jun 2008 10:39
Listing cases with no data as zero, and then calculating a tot "Piet Linden" wrote: On Jun 29, 10:29 am, RichKorea <RichKo...(a)discussions.microsoft.com> wrote: I'm putting together a service database where I keep track of engineer's service time, and I want to have a monthly report that reports all of the service time by individual engineer, with totals ... 30 Jun 2008 01:27
Report with Monthly rows, Yearly columns & 3 pieces of data per mo I have a query with the following results: Year Month AmountDue Fee Payments 2007 1 2007 2 2007 3 2007 4 2007 5 $800.00 2007 6 $1,080.00 2007 7 $150.00 2007 8 $350.00 2007 9 $350.00 2007 10 $350.00 2007 11 $... 30 Jun 2008 01:27
updating result in table I have the following data sr no1. no2. no.3 no.4 no.5 no.6 10hot 10cold 1 1 8 11 25 30 32 2 4 8 19 28 30 45 3 7 14 20 31 35 39 4 4 12 15 20 43 48 5 9 ... 29 Jun 2008 22:24 |