A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to show a field in a report if the criteria calls for it



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2006, 10:41 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.