|
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... 8 Jul 2008 18:15
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... 8 Jul 2008 17:13
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. ... 8 Jul 2008 17:13
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 ... 8 Jul 2008 14:08
IFF Between...And Hi I have a text box in a form and in the CONTROL SOURCE of this text box I want to use an IFF function that evaluates a number. The field is in one table and the fieled is called Results. The problem is that I have to do this for the if the value <200, "something1", or if the value is between 200 and 25... 8 Jul 2008 12:04
Auto set height of vertical line to height of detail section Hi, I have created a Master/Detail report in Access 2007. My detail section has several fields. To separate these fields, I have drawn vertical lines from the very top of the detail section to the very bottom of the detail section. I was hoping that no matter how many records appear in the detail section, t... 8 Jul 2008 11:03
subreport charts on the main report I have a report which has many subreports. I would like to add subreports charts on the main report. The subreports are cross tab non-fixed columns. It seems that I need to have exactly code to run the query to link record source like subreports. I just wonder are there any easy way to access cross tab non... 8 Jul 2008 07:58
* Free Library management & membership software * We are offering our Microsoft Access Library management & membership database 'LIBRARY SOLUTIONS' FREE of charge. To download, please visit our website http://www.base1solutions.com ... 8 Jul 2008 05:55
How to display records in ascending order on a report Hi I have a report that dsiplays query records. I am running this query in ascending order of a Field. But the report is not dsplayed in the same order as query. Any suggestions on how I can correct this ? ... 8 Jul 2008 03:53 |