转置数据表...需要帮助！ [英] Transposing Data Tables...Need Help!

问题描述

我有一个已经附加的清理数据库，并且大部分都根据我的喜好对数据进行转换。但是我想解决一些问题，但无法确定代码中的问题。基本上，文本字段AccountNumber被识别为数据，以及错误填充的帐号和类。如果您运行附件，您将看到我的错误。我感谢任何人帮助解决这个问题。谢谢。

I have a sanitized database which I have attached, and for the most part transposes the data to my liking. There is however a few issues that I would like to fix, but cannot determine the problem in my code. Basically, the text field AccountNumber is being recognized as data, along with the account numbers and classes being populated incorrectly. If you run the attachment you will see my error. I appreciate anyones help in this matter. Thank you.

展开 | 选择 | Wrap | 行号

推荐答案

我有一个已经附加的清理数据库，并且大部分都根据我的喜好对数据进行转换。但是我想解决一些问题，但无法确定代码中的问题。基本上，文本字段AccountNumber被识别为数据，以及错误填充的帐号和类。如果您运行附件，您将看到我的错误。我感谢任何人帮助解决这个问题。谢谢。

I have a sanitized database which I have attached, and for the most part transposes the data to my liking. There is however a few issues that I would like to fix, but cannot determine the problem in my code. Basically, the text field AccountNumber is being recognized as data, along with the account numbers and classes being populated incorrectly. If you run the attachment you will see my error. I appreciate anyones help in this matter. Thank you.

展开 | 选择 | Wrap | 行号

我有一个消毒过的我附加的数据库，并且大部分都是根据我的喜好对数据进行转换。但是我想解决一些问题，但无法确定代码中的问题。基本上，文本字段AccountNumber被识别为数据，以及错误填充的帐号和类。如果您运行附件，您将看到我的错误。我感谢任何人帮助解决这个问题。谢谢。

I have a sanitized database which I have attached, and for the most part transposes the data to my liking. There is however a few issues that I would like to fix, but cannot determine the problem in my code. Basically, the text field AccountNumber is being recognized as data, along with the account numbers and classes being populated incorrectly. If you run the attachment you will see my error. I appreciate anyones help in this matter. Thank you.

展开 | 选择 | Wrap | 行号

AD，


我希望我理解你的问题。每个基金编号应该具有多个类别（即1,2,3,7,8,9）。每个班级都有一个与之相关的百分比。就现场日期而言，我最终会有两张桌子。一个用于当前日期，另一个用于当前日期。我将需要这些日期，因为我将建立这些日期的查询。


希望这有帮助！

AD,

I hope I understand your question. Each fund number should have multiple classes (ie. 1,2,3,7,8,9) to be exact. Each Class will have a percent associated with that. As far as field date is concerned I am going to ultimately have two tables. One for current date and the other prior date. I will need these dates because I will be building queries off these.

Hope this helps!

这篇关于转置数据表...需要帮助！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！