<div>
in the criteria for the student name, use<br />
<br />
nz([Enter Student Name],[Student Name])<br />
<br />
this is assuming that the name of the field you are applying the criteria is [Student Name]<br />
<br />
<br />
post the sql of the query you are using..<br />
<br />

</div>


<div>
SELECT tblHorseAssign.ReportDate,<wbr /> tblHorseAssign.HorseName, tblHorseAssign.ReportedBy,<wbr /> tblHorseAssign.Paid, tblHorseAssign.PaidBy, tblHorseAssign.StartTime, tblHorseAssign.EndTime, tblHorseAssign.StudentName<wbr /><br />
FROM tblHorseAssign<br />
WHERE (((tblHorseAssign.ReportDa<wbr />te) Between [Enter Start Date] And [Enter End Date]) AND ((tblHorseAssign.StudentNa<wbr />me)=nz([En<wbr />ter Student Name],[Student Name])));<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a query that asks the user for a date range and a student name. This works fine. However, I want to have it show ALL students if the user leaves the student name prompt blank. is that possble?<br />
thx experts...BobR
</div>
</div>


I have a query that asks the user for a date range and a student name. This works fine. However, I want to have it show ALL students if the user leaves the student name prompt blank. is that possble?
thx experts...BobR

in the criteria for the student name, use

nz([Enter Student Name],[Student Name])

this is assuming that the name of the field you are applying the criteria is [Student Name]


post the sql of the query you are using..



SELECT tblHorseAssign.ReportDate, tblHorseAssign.HorseName, tblHorseAssign.ReportedBy, tblHorseAssign.Paid, tblHorseAssign.PaidBy, tblHorseAssign.StartTime, tblHorseAssign.EndTime, tblHorseAssign.StudentName
FROM tblHorseAssign
WHERE (((tblHorseAssign.ReportDate) Between [Enter Start Date] And [Enter End Date]) AND ((tblHorseAssign.StudentName)=nz([Enter Student Name],[Student Name])));


Access 2003 Query Criteria

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.