Can it work using Quick ? Works with quiz.

[David Morrison - Corporate]

Yvonne,

Have you tried something like:

FILE customer
SELECT customer IF account_balance > credit_limit
ACCESS customer ...

If so, make sure you put the SELECT before the ACCESS, so that if you have multiple ACCESS statements (paths), the SELECT will apply to all of them.

Thanks.

David Morrison
McBride Electric


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Yvonne Erkes
Sent: Monday, November 15, 2004 11:53 AM
To: powerh-l@lists.sowder.com
Subject: Can it work using Quick ? Works with quiz.



> Hi all.
>
> Would you be able to enlighten me on how to solve a problem I have
> with quick screens vs quiz reporting?
>
> I've been asked to create a quick screen which will display all
> customers that have gone over their overall credit limit. (Customer 
> can have more than one credit card)
>
> The file records store credit limit & account balance...but not the
> difference.
>
> Is there a way of displaying only the customers with total account
> difference being greater than their total account credit limit ?
>
> I'm able to get results using quiz subfiles, but am having problems
> figuring out how to get results using quick.
>
>  
>
>  
>
>  
>
>  
>


-- 
David R. Sowder
Supervisor of Language Acquisition Center
Department of Modern Languages
University of Texas at Arlington
    Work: 817-272-5148  davids@uta.edu    http://langlab.uta.edu/
Personal:               david@sowder.com  http://david.sowder.com/



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.