Current payment due

[Oscar]

Hi,

I'm trying to run a query where I can pull the current payment due on a
account. When I run the query I get the same account repeated since it gives
me the payment due history. What can I enter in the criteria so that it can
only give me the current payment due?

I have three fields: "Due Date", "Payment" and "Escrow Payment"

Thanks

 

[Golfinray]

Do a group by (the little E at the top) and then change the group by for
Payment to max.

 

[MGFoster]

Hi,

I'm trying to run a query where I can pull the current payment due on a
account. When I run the query I get the same account repeated since it gives
me the payment due history. What can I enter in the criteria so that it can
only give me the current payment due?

I have three fields: "Due Date", "Payment" and "Escrow Payment"

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'll have to define "current payment due": Due Date is within 30
days, 15 days, today? When you have that defined the query would look
something like this (for due within 15 days of Due Date):

SELECT ... columns you want shown ....
FROM your table name
WHERE [Due Date] Between Date()-15 And Date()

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSTgthYechKqOuFEgEQJrvACgt0/8OK64YlN6nqlOvMmSPW5VV/AAn2Z2
G7pENiBGZs2tZ6c1/yhzUnV1
=8pjO
-----END PGP SIGNATURE-----