Reports

Conditional Footers in a report
Can someone explain how I can create an expression(I assume and IIF()) that will put a footer in a report if true and not put it in if false? -- frank-a ... 9 Jul 2008 17:50

#Error Message in Report
I have a form, query, and report that I am trying to get to work. The form contains a combo box which lists many services that the user can choose from. This calls the query, then opens the report and displays the information. If I open just the report, I can get the information to populate. If I open just ... 9 Jul 2008 10:37

Passing data to a Report
Currently I have a form that searches my main table using a user defined filter which is stored to a sting variable. The best part of that is that I can then use that string variable to pass as the filter for a report generation. This all works nicely as long as the search form remains the subform of the main for... 9 Jul 2008 11:38

List and count zip codes
I have a ZipCode field and would like to list, and count, every zip code that user has entered. How would I do that? I know how to create a field that counts the number of times user has entered a specific zip code, but how can I display a list of every code entered and the number of times it has been entered... 8 Jul 2008 23:23

crosstab non-fixed column subreport in details section
I have non-fixed column crosstab subreports in details section. I got you can not set recordset property in preview or print. It works when I move subreports in to report header. Are ther any work around to have crosstab no-fixed column subreports in detail section? Your information is great appreciated, ... 8 Jul 2008 20:18

Rotate field on report
Access XP on Windows XP IS there a way in Access to rotate a data field 180 degrees, so that printout will be upside down and backwards? I want to print a name tent, one sheet of paper folded so that names are readable from both sides. Is this functioanlity avauilabel in Access? Or do I have to do this in Publ... 11 Jul 2008 07:53

Strange unbound control problem
Access 2003 on WindowsXP Pro SP2 If I put the following expression into an unbound control: =Trim("Training between "&Format(Now()"d mmmm yyyy")&" & "&Format((Now()+30),"d mmmm yyyy") I get the following result: Between 8 July 2008 & 7 Augu23t 2008 The figures embedded in "August" change every time the r... 10 Jul 2008 16:31

Find Breaks in Data Ranges - Follow-up
NOTE: I posted the following message at the beginning of June but haven't had the time to try the response until now and was wondering just how do I go about trying to make this happen? Where do I put the code, in a query or in a report? Can I just copy and paste the code or do I have to do other things to it... 8 Jul 2008 17:13

Option group doesn't become visible
I have an option group on my report that I would like to become visible depending on some value. I have set up the following in Report_Open(): Me.fratest.Visible = True The problem is that the statement executes, but the option group doesn't become visible. Any ideas what could be wrong? Thank you. ... 9 Jul 2008 13:42

Report Detail - How do I either anchor Lines or box
My task is to make each record in the detailed section of my report "Contained" within a box. I've tried may avenues (grouping, individual lines) but can't seem to get either to grow or shrink as each record expands. How can you do this? The detailed section contains individual apartment complexes that show ... 9 Jul 2008 13:42