asked on 10/3/2011

Access 2003 Query Criteria

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

Microsoft Access

Last Comment

bobrossi56

10/3/2011

Rey Obrero (Capricorn1)

10/3/2011

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..

bobrossi56

10/3/2011

ASKER

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])));

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

10/3/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

bobrossi56

10/3/2011

ASKER

Works great...thx