

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. "synopsis" may belong to another edition of this title.First, let me address the other people commenting on the thread for their own information and learning.
:max_bytes(150000):strip_icc()/gettingstarted-56a227b25f9b58b7d0c748ac.jpg)
Create a Summary view to consolidate and group information.

Use the Autocomplete control to quickly search for related data.Aggregate and display your web app data using totals queries.Create tables in your Access web app using built-in templates.Automate your Access web app with data macros.Build an Access Services web app with Microsoft SharePoint Server.Discover how the experts tackle Access 2013-and challenge yourself to new levels of mastery. You’re beyond the basics, so dive right into Access 2013-and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Conquer Microsoft Access 2013-from the inside out!
