You can also create an embedded query by copying the SQL statement from a named query that is open in SQL View, and then pasting the SQL statement into the Record Source property of a report.
If the RecordSource property for a form or for report is set to an SQL statement, save the SQL statement as a query and then set the RecordSource property to the name of the query.
Als de eigenschap Recordbron voor een formulier of rapport is ingesteld op een SQL-instructie, slaat u de SQL-instructie op als een query en stelt u de eigenschap Recordbron in op de naam van de query.
For more information see Access SQL: basic concepts, vocabulary, and syntax and learn more about how to edit SQL statements to sharpen query results.
Zie Access SQL: basisbegrippen, vocabulaire en syntaxis voor meer informatie en ontdek hoe u SQL-instructies kunt bewerken om betere queryresultaten te krijgen.
Repeat steps 5 through 10 until you have copied and pasted all of the SQL statements for the select queries into the SQL view window of the union query.
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.
Înregistrează-te pentru a accesa mai multe exemple