Is Date Between Start and End

[Guest]

I have bad student who was assigned In School Suspension. Start and End
dates are added to the table.

Name StartDate EndDate
Jane 7/11/2007 7/15/2007
Dave 7/8/2007 7/20/2007


Now I want to have the person who runs ISS select a date and send out the
query results of who is in ISS on 7/14/2007.

I have a form, frmIssDaily, with a combo box, cboIssReport, that has a range
of dates in it. I would like to run the report with the date in cboIssReport
as the parameter in the query.

How? I don't know how to write the query that determines if cboIssReport is
between the start and end dates of the students assigned to ISS.

Can anyone help?

 

[Guest]

Try this --
SELECT [Table-A].Name
FROM [Table-A]
WHERE ((([Forms]![frmIssDaily]![cboIssReport]) Between [StartDate] And
[EndDate]));

 

[John W. Vinson]

I have bad student who was assigned In School Suspension. Start and End
dates are added to the table.

Name StartDate EndDate
Jane 7/11/2007 7/15/2007
Dave 7/8/2007 7/20/2007


Now I want to have the person who runs ISS select a date and send out the
query results of who is in ISS on 7/14/2007.

I have a form, frmIssDaily, with a combo box, cboIssReport, that has a range
of dates in it. I would like to run the report with the date in cboIssReport
as the parameter in the query.

How? I don't know how to write the query that determines if cboIssReport is
between the start and end dates of the students assigned to ISS.

Can anyone help?

SELECT [Name]
FROM [School Suspension]
WHERE [StartDate] <= Forms!frmIssDaily!cboIssReport
AND [EndDate] >= Forms!frmIssDaily!cboIssReport

John W. Vinson [MVP]