Jeff Conrad - Access Junkie - MVP Alumnus If you switch back to Design View, you'll notice that Access created two hidden output columns to show this.
When I save the query and run it, I see only records returned where SomeDate falls within the current month. In my example, I'm using the Criteria line for my SomeDate field in the table.
To define a query in an Access 2013 web app that will return just records with the current month, use the Criteria line for the date column in question like this: Also, the new Related Items Control is unique to Access 2013 web apps.įor the poster of the question, have you considered just creating a saved query that will return all the records in the current month? It sounds like you may be using a RequeryRecords macro action at the view level's On Load event to restrict the records to the current month. So that is why the poster could not provide some of that information. DateSerial, for example, is not an available expression. For example, when using this environment, relationships are defined through lookup fields, you cannot use any VBA code, you cannot get directly to the SQL of any queries you create (you can only use the design window), and the expressions you can use are different since they are SQL expressions which go against the SQL tables that drive the web app. Access 2013 web apps are much different than Access desktop applications. The person posting the question is using an Access 2013 web app which is why they posted their question in the Access web forum. First, let me address the other people commenting on the thread for their own information and learning.
0 kommentar(er)
