Reports

Insert a specific (but variable) date each time a report is run
I am wondering how to insert a date field into a report that will automatically populate with the 20th of the month in which I am running the report. I run these reports several times a month, but the date I need inserted into the report will always be the 20th. How do I set this up? I am using Access 2003 a... 24 Jun 2008 19:32

Running sum in group header
I'm trying to print totals in a group header section on a report, but I'm not getting the results I'm looking for. I have two hidden counters in the StudentID_Header_Section--one keeping a running sum over the group, and the other keeping a running sum over all--but I want to print the group sum in a previous ... 25 Jun 2008 11:54

Access 2007
My report is a letter and the [CUSTODIAN] is connected to 5 [ACTIVITY] and 5 [COSTCENTER#] and I am trying to get and unbound text box to list them like ACTIVITY (COSTCENTER#), ACTIVITY (COSTCENTER#), etc. Please help. Thanx in advance~mjc ... 24 Jun 2008 16:27

Need to format a number in a report, but no number options come up
I have a field on a report which came from an if/then statement, where the value would either be numerical through addition, or if null, "0" would replace the null value. So the column contains entirely numbers and zeros. In my report, I want to format the number, to "standard" for easier reading, but none of... 25 Jun 2008 22:13

selective summing in a report
I work in the financial industry. One of the new types of mutual funds being offered are age-based (depending on what year you were born decides which fund you will move into). I am trying to create a report that will show the money moving out and money moving in will balance. For example, let's say I am map... 25 Jun 2008 09:51

Displaying Graphics
This is a frustrating issue because it has worked before. I have a report that has an image control in the "page header". Also in the page header is a text box that is the path statement to a folder of graphics on my server. As each record chages on my form, the path statement remains the same but the file n... 25 Jun 2008 09:51

how to insert CRLF (carrage return/line feed) in report
Hi on my report I have a variable where I have: "text" & [variable] & "more text" & "another paragraph" Well between the "more text" and "another paragraph", I need to put in a carriage return and 2 line feed so it will have a space between the paragraphs. What is the code for that??? In the old BASIC day... 24 Jun 2008 17:29

Multi-page forms
I am designing a report that is actually just two forms, with a total of six pages. There are a couple of fields that have data from a data source, but for the most part it is just hard-coded fields for forms to be filled out by patients. I got my first two pages designed, but when I go to start the third page,... 24 Jun 2008 12:19

Prints Twice
Really thought I'd find a thread for this issue but I don't see any. Why is it printing twice? This is my command statement to a button as you can see I have an acProview, acPrint and PrintOut (acPreview works fine) but when I try either of the other two I get multiple prints? Any suggestions?? stLinkCriteri... 26 Jun 2008 10:29

Changing Report Name
I have a Macro in Access 2000 that sends a report via email using the 'SendObject' action. The object name, or report name is 'Hector support calls'. I would like add the days date to the report name, simular to the format below (="C:\AccessReports\" & Format(Date(),"ddmmyyyy") & "_Hector support calls.xls") ... 25 Jun 2008 09:51