webDB组合框显示重复的值 - 查询工作正常 [英] webDB combobox shows duplicated values - Query works fine
问题描述
晚上好。
i有一张桌子,可以存储日期,学生姓名和课程(特定学生因为不满而错过)
i创建了一个查询,所以我可以回想起特定的日期''aapscence。我从组合框中选择可用日期,但我唯一不想要的是组合框中的重复值。
例如,如果在12/23那里有3名学生不在场,组合框将显示3次12/23。
我正在研究Access 2010支持WEB的数据库。
非常感谢
i我附加数据库所以你可以看到我的意思
< blockquote>请发布您正在使用的当前SQL来填充ComboBox。答案可能涉及SELECT子句的DISTINCT谓词,但是对于更有帮助的答案,我们真的需要在问题中看到更多细节。
展开 | 选择 | Wrap | 行号
这就是我的意思,假设您的日期字段被调用[Field1],您的表实际上被称为[Table1]。
此示例显示在多行上,但如果愿意,可以在一行中使用,只要您将每个元素分开(确保至少有一个空格替换任何新行): br />展开 | 选择 | Wrap | 行号
Good evening.
i have a table that stores dates, names (of the students) and courses (that the particular student missed, because of apscence)
i created a query, so i can recall a specific dates'' aapscence. i choose the available dates form a combobox, but the only thing i dont want is the duplicate values in that combobox.
for example if, on 12/23 there where 3 students not present, the combobox will show three times 12/23.
I am working on an Access 2010 WEB-enabled database.
Thank you very much
i am attaching the database so you can see what i mean解决方案Please post the current SQL you are using to populate the ComboBox. The answer will probably involve the DISTINCT predicate of the SELECT clause, but for a more helpful answer we really need to see more detail in the question.
Expand|Select|Wrap|Line Numbers
That is exactly what I mean assuming your date field is called [Field1] and your table is actually called [Table1].
This example is shown on multiple lines but can be used in a single line if preferred, as long as you separate each element (Ensure at least one space replaces any new line) :
Expand|Select|Wrap|Line Numbers
这篇关于webDB组合框显示重复的值 - 查询工作正常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文登录 关闭
扫码关注1秒登录发送“验证码”获取 | 15天全站免登陆