Is Date Between Start and End


G

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?
 
Ad

Advertisements

G

Guest

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

Advertisements

J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top