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
|
|||
|
|||
how to show a field in a report if the criteria calls for it
I have a database that keeps track of work orders with all pertinent
information in one table. I have a parameter query set up to search for certain criteria (status, location and begin and end dates). My report is set to run off of the query. The criteria for status is setup to allow for comp, inprg and is null. Like "*" & [Select a status] & "*" Or Is Null there is a field for completed date in the query that will only show an actual date if the work order is either completed or the criteria is left blank to allow all work orders to show on the report (comp or inprg). I would like to set it up to only show this completed date field to show on the report if there is going to be informtion in it. I thought about trying to use an if statement where it would be true if the status field were either comp or null and in that case allow the field to show, but if it is still inprg then the field would not show. I do not know how to tell it to show the field though. Any help would be greatly appretiated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using a form with combo box to input criteria | Christina | Using Forms | 16 | February 3rd, 2006 08:47 PM |
sorting data in a report | David | Setting Up & Running Reports | 21 | October 14th, 2005 03:05 PM |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |