<div>
Where do you want to display the result of the query, you can display things in a form, report or you can simply use the Query wizard and put your query there and it will appear under the Queries list then you can click and run that.<br />
<br />
What do you exactly want to do ?
</div>


Where do you want to display the result of the query, you can display things in a form, report or you can simply use the Query wizard and put your query there and it will appear under the Queries list then you can click and run that.

What do you exactly want to do ?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
On an Access form I want to have a list that is pulled from a query or table using SQL statement. <br />
I am using the report to create an invoice so data will be pulled from the &quot;Invoices&quot; table and <br />
the &quot;Invoice Details&quot; tables using the ID of the invoice.<br />
So I want to use code to build a SQL statement eg &quot;Select Description, Unit Price, Amount From [Invoice Details] Where InvoiceID = &quot;&nbsp;&amp; oID<br />
How do I achieve this?
</div>
</div>


Hi

On an Access form I want to have a list that is pulled from a query or table using SQL statement. 
I am using the report to create an invoice so data will be pulled from the "Invoices" table and 
the "Invoice Details" tables using the ID of the invoice.
So I want to use code to build a SQL statement eg "Select Description, Unit Price, Amount From [Invoice Details] Where InvoiceID = " & oID
How do I achieve this?

Microsoft Access - List of Data on a Form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.