dim D as an intger
D=year(Date())
U1 = DCount("[OccupantID]", "[RoomOccupations]", "[DepartureDate] > Date() And [FY]=D")
i want to count the records in the table RoomOccupations where Departuredate is greater than the current date and the year is current year.
FY is a calculated filed from [Departuredate] i.e Year(departuredate) in the main table RoomOccupations
i am getting an error
D=year(Date())
U1 = DCount("[OccupantID]", "[RoomOccupations]", "[DepartureDate] > Date() And [FY]=D")
i want to count the records in the table RoomOccupations where Departuredate is greater than the current date and the year is current year.
FY is a calculated filed from [Departuredate] i.e Year(departuredate) in the main table RoomOccupations
i am getting an error