Reports
in [Access]
|
bread association between label and text box Hi, I am using Access 2007. I created a report using the Wizard. Now I have column labels in my page header section and I have associated text boxes in my detail section. Sometimes I don't want the column label, but when I try to delete them, I end up deleting both the column label and the text box. Is t... 24 May 2010 14:36
Label for totals in group footer I have a group header in my report called “Category” that contains two categories. I also have a group footer for category that contains my sum/totals. I want to add a label beside the totals in the group footer that relates to the category. How do I do this? I assume I need some type of expression. Can an... 24 May 2010 20:11
Complex Count function with a condition Hello, I have a table named, tbl_pt_records as shown below. ID AdmitDate EndDate AdType Place Comments NH 1*01 4/15/2009 4/27/2009 InitialAdmit Hospital Discharge to Home ABC 1*01 5/1/2009 5/3/2009 Readmit Hospital Discharge to Nursing ABC 1*01 5/3/2009 5/5/2009 Initial... 24 May 2010 14:36
Using a parameter in a report Hi, I am using Access 2007. I have created a report where the RecordSource is set to something like the following: SELECT MyTable.Tag1, MyTable.Tag2 FROM MyTable WHERE MyTable.Tag1 = 999; The WHERE clause is hard coded so that it only looks for records where Tag1 = 999. Rather than having this hard-coded... 24 May 2010 12:21
Sorting/Grouping ... Show a month if Zero (Access 2007) I've created a fairly simple database. Mostly it has an order date, and the number of items ordered. I've created a report that will show order counts by month (by grouping/sorting by order date). My problem is this ... if the order count for a month is Zero ... then the month doesn't show on the list at... 24 May 2010 12:21
Write Name of Report Query in Report Footer Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer. ... 24 May 2010 11:15
Hide Sub Report(s) when records are null I am running Access 2007 sp2 MSO. I have a report that has three (3) sub reports. There are times when not all three sub reports have values to display. Is there a way to code the given report to not be visible if there are no records to report? The second part of this question would be if there is a way to mak... 23 May 2010 23:24
Hide Sub Report(s) when records are null I am running Access 2007 sp2 MSO. I have a report that has three (3) sub reports. There are times when not all three sub reports have values to display. Is there a way to code the given report to not be visible if there are no records to report? The second part of this question would be if there is a way to mak... 24 May 2010 12:21
Grouped/Sorted Report by Month I have a fairly simple access database. I've created a report grouped by Category and Month... with a total per month. My problem is that the months with no total don't show on the report. Is there a way to make the month show with a zero total? ie. January - 24 orders February - 30 orders Mar... 24 May 2010 00:29
new crosstab option? I have a table that displays results horizontal, that needs to be verticle, so it shows up on a report in one page, instead of one record per page. example: table: PRODUCT: TYPE: LEAKS: UNLEAD STP YES DIESEL STP NO PREMIUM STP NA Need this on a one page r... 24 May 2010 00:29 |