MS Access 365 Filtering between two dates using Embedded Macros
The organisation I work for has disabled VBA coding in MS Applications, so what I am trying to do in MS Access 365 is filter between two dates using embedded Macros. All help would be greatly appreciated.
Here's my code, but it's not working:
[DateOfReport]=[Forms]![DetailsReportFrm]![FirstDateTxt]
And [DateOfReport]=[Forms]![DetailsReportFrm]![SecondDateTxt]
Solution
A field cannot meet the criteria of being equal to two values. Instead of And, use OR operator or BETWEEN AND.
[DateOfReport]=[Forms]![DetailsReportFrm]![FirstDateTxt]
Or [DateOfReport]=[Forms]![DetailsReportFrm]![SecondDateTxt]
or
[DateOfReport] Between [Forms]![DetailsReportFrm]![FirstDateTxt]
And [Forms]![DetailsReportFrm]![SecondDateTxt]
- Converting VARCHAR 'MMM-dd-yyyy' to DATE 'yyyymmdd' in SQL
- Convert epoch to days
- Iterating through a range of dates in Python
- Obtaining regular-spaced observations from irregular time series
- Get weekday name from date in PySpark
- How can I calculate the number of working days between two dates
- Convert month name to number in PySpark
- How to get list of 2nd and 4th Saturday dates in SQL Server?
- Return month name in specified locale
- Spark dataframe string to month
- Change month numbers to month name in a dataframe (PySpark)
- Altering WinSCP timestamp, get file(s) from a specified date-named folder
- Map monthname to monthnumber in Azure Databricks using Scala
- SQL server: Get record with date closest to given date
- T-SQL How to select the nearest earlier date
- Find closest earlier date in SQL Server
- Convert Milliseconds to yyyy-MM-dd HH:mm:ss format Javascript
- Get period start of month period (bimester, trimester, quarter, and semester)
- Event load can't be found BC30590
- Excel - How to convert the combination of year, week number and day of week to calendar day?
- MySQL date format
- After ingesting a string using SSIS I am unable to convert into date format
- How to stretch an axis of type date in R?
- How to get current time and date in C++?
- get the last thursday before a date in PHP
- Convert date format in vue js with laravel
- Date and datetime support
- Excel - Nested IF(AND()) Statements to Report Multiple Parameters
- How to check whether an object is a date?
- Need efficient way to sort list of strings (dates) in Scala. (Avoiding the darkness of Java.)