<div>
Boy I feel like a dummy now LOL<br />
<br />
That was brain dead to the extreme on my part<br />
<br />
Thanks<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi - <br />
<br />
I have the below query but I want it to return just the analyst name that starts with whatever characters are put in as the parameter (for example 'joh' but I can't seem to get it to come to fruition<br />
<br />
The below sysntax returns everything that contains whatever the parameter was.....<br />
<br />
<br />
Thanks for any help<br />
<br />
<br />
<br />
SELECT *<br />
FROM QTab <br />
WHERE analyst Like '*' &amp;&nbsp;[Enter Analyst here];<br />

</div>
</div>


Hi - 

I have the below query but I want it to return just the analyst name that starts with whatever characters are put in as the parameter (for example 'joh' but I can't seem to get it to come to fruition

The below sysntax returns everything that contains whatever the parameter was.....


Thanks for any help



SELECT *
FROM QTab 
WHERE analyst Like '*' & [Enter Analyst here];


MS Access 2010 SQL Query question

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

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.