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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |