查找第一笔付款 [英] Find first payment

问题描述

我的付款日记帐表类似于以下内容：


ClientID日期金额类别

123 1/2/01 -100 PMT

123 1/5/01 100 NSF

123 1/20/01 -35 PMT


我需要能够从每个没有相应NSF（将始终为金额* -1）的clientid中找到第一笔付款。我试图用JOIN做这个但是我没有运气。

解决方案

发布你目前为止所做的查询。 Date列的数据类型是什么？

发布您目前为止所做的查询。 Date列的数据类型是什么？

日期是日期类型字段。到目前为止我的查询看起来像：

展开 | 选择 | Wrap | 行号

仍在寻找答案... .anyone？

I have a payment journal table that is similar to the following:

ClientID Date Amount Category
123 1/2/01 -100 PMT
123 1/5/01 100 NSF
123 1/20/01 -35 PMT


I need to be able to find the first payment from each clientid that does NOT have a corresponding NSF (which will always be Amount *-1). I''ve tried to do this with a JOIN but I''m not having any luck.

解决方案

Post the query you have made so far. What is the data type of Date column?

Post the query you have made so far. What is the data type of Date column?

The Date is a date type field. The query I have so far looks like:

Expand|Select|Wrap|Line Numbers

Still looking for an answer to this....anyone?

这篇关于查找第一笔付款的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！