创建仅显示特定月份的查询 [英] Create Query that shows only certain month

问题描述

我必须在MS Access中编写一个查询，它只显示7月份的发票。我可以使用大于和小于该月的第一天和最后一天来执行此操作吗？

解决方案

您的问题没有说明表格结构。但是下面的伪查询应该可以工作。

  SELECT  * 
  FROM 发​​票
  WHERE 月（InvoiceDate）=  7  

I have to write a query in MS Access where it only shows the invoices in the month of July. Can I do this with a greater than and less than from the first and last day of the month?

解决方案

Your question did not say anything about the table structure. But the following pseudo query should work.

SELECT *
FROM Invoice
WHERE month(InvoiceDate) = 7

这篇关于创建仅显示特定月份的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！