如何将所有交易拉入1条记录 [英] How to pull all transactions into 1 record

问题描述

你好 - 我是相对的菜鸟...


我有（继承）一个表，每个ID都有多个记录详细说明

日期和交易。


ID日期金额

123 1/15/04 $ 1500.00

123 3/25/04 $ 1600.00


为了完成对交易的分析，我需要

来获取日期和$ info并添加到新字段中的第一条记录，

理想情况如下：


ID日期金额Date2金额2等

123 1/15/04 $ 1500.00 3/25 / 04 $ 1600.00


如果在设计视图中使用查询可以做到这一点，或者这需要一些SQL代码（其中是我的知识非常有限（b
）。我假设必须有一些标准来检查

ID以检查它是否与之前的记录相同，跟踪

哪个迭代它的记录然后用记录中的数据填充一个新字段

我只是不知道如何...

任何帮助都将不胜感激。谢谢 -


Rob

Hi there - I''m a relative rookie to this...

I have (inherited) a table with multiple records for each ID detailing
dates and transactions.

ID Date Amount
123 1/15/04 $1500.00
123 3/25/04 $1600.00

In order to complete an analysis of the transactions over time, I need
to take the date and $ info and add to the first record in new fields,
ideally like this:

ID Date Amount Date2 Amount2 etc.
123 1/15/04 $1500.00 3/25/04 $1600.00

Haven''t figured out if this is possible using a query in design view,
or whether this requires some SQL code (of which I have very limited
knowledge). I''m assuming there has to be some criteria to examine the
ID to check if it''s the same as the previous record, keep track of
which iteration of the record it is and then populate a new field with
the data from the record - I just have no idea how...
Any help would be appreciated. Thanks -

Rob

推荐答案

1500.00

123 3/25/04

1500.00
123 3/25/04

1600.00

为了完成一段时间内的交易分析，我需要

取日期和

1600.00

In order to complete an analysis of the transactions over time, I need
to take the date and

信息并添加到新字段中的第一条记录，

理想情况如下：


ID日期金额Date2金额2等

123 1/15/04

info and add to the first record in new fields,
ideally like this:

ID Date Amount Date2 Amount2 etc.
123 1/15/04

这篇关于如何将所有交易拉入1条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！