sql - 有没有办法根据两个条件过滤 ms-Access 记录?
问题描述
我在 Microsoft Access 方面没有经验,而且我在实习中完成任务时遇到了困难。我得到了一个记录列表,我应该创建一个查询,根据国家和选择的年份选择随机记录(获胜者)。通过实现以下 SQL 代码,我能够进行随机化位:
`SELECT TOP 10 Sheet2.name, Sheet2.country, Sheet2.Year
FROM Sheet2
ORDER BY Rnd(-(100000*ID)*Time());
`
我的问题是我想选择获奖者的数量并从我的表单和年份的下拉列表中选择国家,并根据选择过滤记录。
任何帮助,将不胜感激!
解决方案
这应该有效:
SELECT TOP 10 Sheet2.name, Sheet2.country, Sheet2.Year
FROM Sheet2
WHERE Sheet2.country = [Forms]![YourFormName]![cboCountry]
AND Sheet2.Year = [Forms]![YourFormName]![txtYear]
ORDER BY Rnd(-(100000*ID)*Time());
其中cboCountry和txtYear是表单上的两个控件。
推荐阅读
- android - (Kotlin Android), Using XML-RPC, encoded images to BASE64 are sent for a long time
- r - outlier detection for a grouped (clustered) data
- windows - Is there a way to obtain Source Code of a PDF file in Windows?
- python - Explain the parenthesis syntax used in map
- json - Using Pickle to serialise large objects - what causes 'Memory error'
- java - Interfaces implicitly declaring public methods of Object class?
- reactjs - Submitting a form Firebase for details of a Product with an array of multiple images with getDownloadURL and setting to State (productThumbnail)
- javascript - Insert value inside
- bash - Second job in chained ampersand crontab still running even if previous one failed. Why?
- algorithm - how can i apply fft in non multiplication problem?