<div>
Oh - and the query being used in this query - is the report record source
</div>


Oh - and the query being used in this query - is the report record source

<div>
1) A Textbox does not have a Record Source, it has a Control Source.<br />
2) You cannot put an SQL statement directly in a Text Box Control Source.<br />
<br />
mx
</div>


1) A Textbox does not have a Record Source, it has a Control Source.
2) You cannot put an SQL statement directly in a Text Box Control Source.

mx

<div>
That's what I put it in... my bad<br />
<br />
Here's the error<a href="https://filedb.experts-exchange.com/incoming/2015/03_w13/905576/Err.png" target="_blank" title="Err.png (11 KB)"><img alt="Err.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/03_w13/800_905576/Err.png" /></a>
</div>


That's what I put it in... my bad

Here's the errorErr.pnghttps://filedb.experts-exchange.com/incoming/2015/03_w13/905576/Err.png

Err.png

<div>
Excellent as always - Thank you people
</div>


<div>
<div class="content wysiwyg-content">
Although it is uncommon - I need to put a huge query in a record source of a textbox on an access report - is this in the proper syntax?<br />
<br />
SELECT Sum([qryPlanner-ProdMethod<wbr />-WkREPORT]<wbr />.Sales), Sum([qryPlanner-ProdMethod<wbr />-WkREPORT]<wbr />.Fcst)<br />
FROM [qryPlanner-ProdMethod-WkR<wbr />EPORT]<br />
WHERE ((([qryPlanner-ProdMethod-<wbr />WkREPORT].<wbr />WkBeginDat<wbr />e)&gt;=Date()<wbr />-32)) OR ((([qryPlanner-ProdMethod-<wbr />WkREPORT].<wbr />WkBeginDat<wbr />e)&lt;=Date()<wbr />-6));
</div>
</div>


Although it is uncommon - I need to put a huge query in a record source of a textbox on an access report - is this in the proper syntax?

SELECT Sum([qryPlanner-ProdMethod-WkREPORT].Sales), Sum([qryPlanner-ProdMethod-WkREPORT].Fcst)
FROM [qryPlanner-ProdMethod-WkREPORT]
WHERE ((([qryPlanner-ProdMethod-WkREPORT].WkBeginDate)>=Date()-32)) OR ((([qryPlanner-ProdMethod-WkREPORT].WkBeginDate)<=Date()-6));

Access report Record SOurce Query Syntax

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.