Wrox Programmer Forums
|
Other Programming Languages If you have a coding issue to discuss about another language that really isn't provided for in any other forum here (not ASP.NET C#, C++, VB, PHP, JavaScript, Python, Java, Perl, Applescript, XML or any of the other forum topics we have), post it here. Enough discussion on a language we don't have covered could prompt a new forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Other Programming Languages section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 21st, 2006, 04:41 PM
Registered User
 
Join Date: Feb 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default selection criteria...

I have a report with a paramter field.

The user picks from a list. The list contains unique ID names that are used as part of the selection criteria.

However, the users also want an option for ALL.

{?Underwriter Account} = Paramater field
{Report_claim.underwriter_account} = data field

In the selection criteria, I have something like

if {?Underwriter Account} <> '' then
   {Report_claim.underwriter_account} = {?Underwriter Account}

But I also want to add an option for ALL, but what would {Report_claim.underwriter_account} = ?

Thanks - Darren


Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
Selection criteria on index form - p422 kota BOOK: Access 2003 VBA Programmer's Reference 7 October 10th, 2006 11:39 PM
Criteria in Query lryckman Access 1 June 23rd, 2004 11:11 AM
Print selection criteria on report sjperl VB Databases Basics 1 May 3rd, 2004 11:41 PM
what is the criteria to get one record yylee Access 1 April 29th, 2004 04:19 PM
Report Heading Based On Selection Criteria Fo CloudNine Access 5 March 4th, 2004 08:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.