If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Reports
I need help developing a dynamic report in which the fields in the report
change. Not the field values, but the actual fields themselves. If the value of the field is null, then I do not want the field to appear on the report. Here is my situation. I am developing an event planning system. Each event gets a unique id. However each event may occur at several different locations or times. A conference (event) may have multiple sessions. Here is my problem. Some sessions require tables, for example, others don't. How do I create a report which will show the tables field only when a table is needed? |
#2
|
|||
|
|||
Dynamic Reports
In the Format event of the section the text box is in, you can set it's
visible property: Me.txtTables.Visible = Not IsNull([MyBoundFieldName]) "Hannah B." wrote: I need help developing a dynamic report in which the fields in the report change. Not the field values, but the actual fields themselves. If the value of the field is null, then I do not want the field to appear on the report. Here is my situation. I am developing an event planning system. Each event gets a unique id. However each event may occur at several different locations or times. A conference (event) may have multiple sessions. Here is my problem. Some sessions require tables, for example, others don't. How do I create a report which will show the tables field only when a table is needed? |
#3
|
|||
|
|||
Dynamic Reports
You normalize your "Access tables". I assume you have fields in your table
that identify various event needs. I would place these in a related table. This would be similar to the Orders (events) and OrderDetails (event needs). If an order doesn't include tables in the order details, it won't show in the order or invoice report. I could be wrong. Prove it. -- Duane Hookom MS Access MVP -- "Hannah B." wrote in message ... I need help developing a dynamic report in which the fields in the report change. Not the field values, but the actual fields themselves. If the value of the field is null, then I do not want the field to appear on the report. Here is my situation. I am developing an event planning system. Each event gets a unique id. However each event may occur at several different locations or times. A conference (event) may have multiple sessions. Here is my problem. Some sessions require tables, for example, others don't. How do I create a report which will show the tables field only when a table is needed? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concecutive page numbers across differnet reports? | margaret | Setting Up & Running Reports | 0 | February 15th, 2006 03:48 PM |
Need Reports to Reference New Queries | Jenn | General Discussion | 0 | January 31st, 2005 06:17 PM |
Dynamic Reports | Bryan | Setting Up & Running Reports | 7 | September 3rd, 2004 10:06 PM |
Need help w/ reports | Tom | Setting Up & Running Reports | 0 | June 25th, 2004 05:59 PM |
ACCESS Reports | Steve | Setting Up & Running Reports | 2 | June 7th, 2004 02:58 PM |