主页 / user-28105415

Eliz A Purves's questions

Martin Hope
Eliz A Purves
Asked: 2025-04-20 18:32:43 +0800 CST
  • 5

以下表达式适用于我的基于查询的财务报告（计算文本框），用于汇总当月收入和支出的类似收入

=Sum(IIf([be,bi,e,i]="i",[Inc £],0))

不过，我希望能够将当前月份与前几个月（即年初至今）相加，并尝试以下方法

 =Sum(IIf([EntryDate] >=DateSerial(Year(Date()),2,1) And <=Now()),(([be,bi,e,i]="i"),[Inc £],0))

但收到以下错误消息 - 您输入的表达式包含无效语法。您可能输入了逗号，但没有为其前面添加值或标识符。

我将非常感激对这个问题的任何帮助。

提前致谢。

已经将我的表情改为

=Sum(IIf([EntryDate] >=DateSerial(Year(Date()),2,1) And [EntryDate] <=Now()),(([be,bi,e,i]="i"),[Inc £],0))

但现在出现错误 - 您输入的表达式有一个包含错误数量参数的函数。

我想我需要更多的括号，但不确定它们应该放在哪里。

谢谢

ms-access
Martin Hope
Eliz A Purves
Asked: 2025-02-08 13:57:03 +0800 CST
  • 6

我在这里找到了以下查询，发现它很有用。使查询适用于我的数据库后，我现在想向其中添加一个参数以过滤掉不需要的记录 - 该参数所需的表名为 Season，与成员表的联接为 seasons.idseasons = members.members id no，参数为 WHERE (((seasons.Season)=[enter season]))。

Select  (tMin.Initial1 + ' and ' + tMax.Initial1) As initial, tMax.surname1 As surname, tMax.[first line address], tMax.[second line address], tMax.town, tMax.postcode, tMax.GroupCount From (Select Distinct Max(initial) As initial1, Max(surname) As surname1,[first line address], [second line address], town, postcode, Count() As  GroupCount From members Group By [first line address], [second line address], town, postcode Having Count() = 2) As tMax Inner Join

   (Select Distinct Min(initial) As initial1, Min(surname) As surname1, [first line address],[second line address], town, postcode, Count(*) As GroupCount
   From members
   Group By [first line address], [second line address], town, postcode
   Having Count(*) = 2) As tMin

           On (tMax.[first line address] = tMin.[first line address]) And 
              (IIf(IsNull(tMax.[second line address]), '', tMax.[second line address]) = IIf(IsNull(tMin.[second line address]), '', tMin.[second line address])) And 
              (tMax.town = tMin.town) And  
               (tMax.postcode = tMin.postcode)

UNION ALL Select Max(initial) As initial1, Max(surname) As surname1, [first line address], [second line address], town, postcode, Count() As GroupCount From members Group By [first line address], [second line address], town, postcode Having Count() = 1 Or Count(*) > 2

ORDER BY surname, initial, town, postcode;

不确定参数应该放在代码中的什么位置。你能帮忙吗？

ms-access