如何根据用户请求选择前三个记录和另一个待处理记录 [英] How to select the first three Records and another one record pending on user request

问题描述

你好吗？

我有一张桌子说tblChoose，最多有40条记录和10个字段。我想选择前三个记录和用户选择的第四个记录。例如，一个用户决定选择恰好第四个记录，另一个用户可以选择第23个记录，这样每个用户选择的总记录数为4，默认情况下为3，用户请求则为4个。

选择之后我想要将此结果转换为特定的报告模板。

请帮助？

解决方案

如果我理解正确，您需要做出3个选择随机为用户，然后允许用户为他/她自己做第4选择？然后，您需要根据这4个选项为用户生成报告，包括tblChoose中的所有字段？

是的！确切地说

但是三个记录必须在那里，第四个记录取决于用户的决定，然后转置结果四个选择

这里的主要问题是转置一部分。我想在选择之后将所有行更改为列和所有列到行，并且必须在同一模板上报告此结果查询

Hi there?
I have a table say tblChoose with up to 40 records and about 10 fields. I want to choose the first three Records and the forth record on user choise. Eg One user decided to select exactly forth record and another may choose the 23th record so that the total records selected per user is 4, three by default and forthone by user request.
After the selection I want to transpose this result to a specific report`s Template.
Please help?

解决方案

If I understand you correctly, you want 3 choices made randomly for the User, then allow the User to make the 4th choice for him/herself? You then want a Report generated for the User based on these 4 choices including all the Fields in tblChoose?

Yes! Exactly
But three Records must be there and the forth one is depending on user decision and then Transpose the resulted four Selections

The main problem in this is the transpose part of it. I want all rows to be Changed to Column and all Column to Rows just after the selection, and this resulted query has to be reported on the same template always

这篇关于如何根据用户请求选择前三个记录和另一个待处理记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！