Report Hey! First, sorry my bad English! I have created a results page of a report in Access 2007. I want to make a mark AFTER the first third of the report. So if there are 33 participants, I would like it to be characterized by the eleventh. Is this possible in a report? Hope someone can help me with this! ... 11 May 2010 00:18
Detect when detail section pushes to 2nd page Is there a way of detecting when detail section pushes to 2nd page via code. Sometimes my report group needs 2 pages and sometimes it don't, but I need a diiferent set of conditions when it does. Thanks, for any help! Wally ... 19 Apr 2010 14:41
Problem with repeating values in report I have a special kind of “eliminate blank lines” question. Here's a simplified version of the issue. I have a query with multiple joins which returns a key value (Name), one or more (there will always be at least one) “children” values and then another column pulling different children into the join. The que... 18 Apr 2010 15:18
Pie Chart Formating I am using Access 2003 SP3 in Win Xp. I am trying to produce a pie chart with Data Labels having 1. Regions, 2. Value, 3. %. Everything is fine in Design View, the value shown as £1,234 (as formated)but in the report the Value is displayed as 1234.5678 ie not formated and no £ sign. I have formated everywhere I... 17 Apr 2010 17:26
show total in each page , How I have a report which is contains : ID , Name , Salary ..... etc , 1.................. 2................ 3.............. page 1 total [salary] = ??? -------------------------------------------------------- ID , Name , Salary ..... etc , 1.................. 2................ ... 17 Apr 2010 18:33
Trouble with my sorting and grouping I a using Access 2007. I have a report based on a query. In the report I am using the inbuilt sorting & grouping feature to calculate totals for each footer record (including percentages of the grand total.) This all works fine but the records are coming out in alpha order (company names) - I want them to be s... 20 Apr 2010 07:15
Grouping not working right I have created a report with three "groups" 1) Candidate -- there are many candidates 2) Year -- there are 3 years (2010, 2009, 2008) 3) Category -- there are two categories (billable, non-billable) It works fine until it gets to the third category. It then prints all the billable with a total and then a ... 17 Apr 2010 23:59
fter acCmdZoom150 I'm using acCmdZoom150 when previewing a report. However, after the report is displayed, I usually need to use the scroll bars in order to center the report as well as move it vertically to read the top. Is there code I can use to automatically position it? ... 17 Apr 2010 15:13
Two Reports into one pdf file Is it possible to output two different reports into one pdf file, and if so, how Thanks in adavance. ... 17 Apr 2010 15:13
Formatting currency within a report text box expression I'm trying to create a mail merge letter from a 2007 ACCB database using a report (Word can't cope with the filter) To keep the text flowing to allow for expansion of various field values, I've put the following in a text box. ="According to my records you " & [Expr2] & " " & [KEYNO] & ", have made a total ... 17 Apr 2010 09:41 |