<div>
Try this: pk is the primary key field of the table.<br />
<br />
SELECT [Q-ProjectTime].HoursDate,<wbr />[Q-Project<wbr />Time].Hour<wbr />s<br />
FROM [Q-ProjectTime]<br />
WHERE ([Q-ProjectTime].HoursDate<wbr />&gt;(Select Max([Q-ProcessPeriods].[St<wbr />artDate]) from [Q-ProcessPeriods] WHERE pk =(select min(pk) from [Q-ProcessPeriods]))
</div>


Try this: pk is the primary key field of the table.

SELECT [Q-ProjectTime].HoursDate,[Q-ProjectTime].Hours
FROM [Q-ProjectTime]
WHERE ([Q-ProjectTime].HoursDate>(Select Max([Q-ProcessPeriods].[StartDate]) from [Q-ProcessPeriods] WHERE pk =(select min(pk) from [Q-ProcessPeriods]))

<div>
<div class="content wysiwyg-content">
I wish to create a query which findsall dates greater than the one defined in the first row of another unique query<br />
<br />
I have done this with the criteria date showing in a live form but don't know how to bypass the form to go to the first date shown inquery directly<br />
<br />
IE something like<br />
<br />
SELECT [Q-ProjectTime].HoursDate,<wbr />[Q-Project<wbr />Time].Hour<wbr />s<br />
FROM [Q-ProjectTime]<br />
WHERE ((([Q-ProjectTime].HoursDa<wbr />te)&gt;&quot;[Q-Pr<wbr />ocessPerio<wbr />ds].[Start<wbr />Date](firs<wbr />t row only)&quot;));<br />
<br />
Any suggestions?
</div>
</div>


I wish to create a query which findsall dates greater than the one defined in the first row of another unique query

I have done this with the criteria date showing in a live form but don't know how to bypass the form to go to the first date shown inquery directly

IE something like

SELECT [Q-ProjectTime].HoursDate,[Q-ProjectTime].Hours
FROM [Q-ProjectTime]
WHERE ((([Q-ProjectTime].HoursDate)>"[Q-ProcessPeriods].[StartDate](first row only)"));

Any suggestions?

Creating Access Query with Criteria data from first row of another query

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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.