Can it work using Quick ? Works with quiz.

[Yvonne Erkes]

Hi David.

Unfortunately this wouldn't work, as each customer can have multiple
credit cards.
This means I need a total value of all account balances for a customer
and a total value of all credit limits for that customer before I can
perform the 'select'

Got any other ideas ??

Yvonne.

-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com] 
Sent: Tuesday, November 16, 2004 9:04 AM
To: Yvonne Erkes; powerh-l@lists.sowder.com
Subject: RE: Can it work using Quick ? Works with quiz.


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.