PC Review


Reply
Thread Tools Rate Thread

Multi-query issue

 
 
Antavas
Guest
Posts: n/a
 
      14th Jul 2008
I have a data table that contains an open date and close date for each entry.
I've been asked to create a report that does the following 3 things:

allows a date range for when items are opened (easy enough based off the
open date)
allows a date range for when items are closed(also easy because of the
between [] and [])

now the real issue I'm having is this third item. Based off of whatever open
range picked in Item #1 I need to generate a list of issues opened prior to
whichever start date is chosen and out of those issues I need to show only
the ones that stayed open past the end date of the range.

I've gone around this a few different ways and I can't get it to work. I've
tried to do this as seperate quieries (the open date query and close date
query have been easy) I can't get this third one to work though. I just want
to be able to have a query that looks at the date range I put in, gives me
the cases opened before the start of my selected date and still open at the
end of my selected range.

I also need to turn this all into a report (hopefully in one report)

Can everything be done in 1 query?

 
Reply With Quote
 
 
 
 
John Spencer
Guest
Posts: n/a
 
      14th Jul 2008
The criteria should look something like the following.

WHERE [OpenedDate] <= [Start Date of Period] and [ClosedDate] >= [End Date of
Period]

I'm not sure what you are attempting to accomplish from your description.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Antavas wrote:
> I have a data table that contains an open date and close date for each entry.
> I've been asked to create a report that does the following 3 things:
>
> allows a date range for when items are opened (easy enough based off the
> open date)
> allows a date range for when items are closed(also easy because of the
> between [] and [])
>
> now the real issue I'm having is this third item. Based off of whatever open
> range picked in Item #1 I need to generate a list of issues opened prior to
> whichever start date is chosen and out of those issues I need to show only
> the ones that stayed open past the end date of the range.
>
> I've gone around this a few different ways and I can't get it to work. I've
> tried to do this as seperate quieries (the open date query and close date
> query have been easy) I can't get this third one to work though. I just want
> to be able to have a query that looks at the date range I put in, gives me
> the cases opened before the start of my selected date and still open at the
> end of my selected range.
>
> I also need to turn this all into a report (hopefully in one report)
>
> Can everything be done in 1 query?
>

 
Reply With Quote
 
 
 
 
Amy Blankenship
Guest
Posts: n/a
 
      14th Jul 2008

"Antavas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a data table that contains an open date and close date for each
>entry.
> I've been asked to create a report that does the following 3 things:
>
> allows a date range for when items are opened (easy enough based off the
> open date)
> allows a date range for when items are closed(also easy because of the
> between [] and [])
>
> now the real issue I'm having is this third item. Based off of whatever
> open
> range picked in Item #1 I need to generate a list of issues opened prior
> to
> whichever start date is chosen and out of those issues I need to show only
> the ones that stayed open past the end date of the range.
>
> I've gone around this a few different ways and I can't get it to work.
> I've
> tried to do this as seperate quieries (the open date query and close date
> query have been easy) I can't get this third one to work though. I just
> want
> to be able to have a query that looks at the date range I put in, gives me
> the cases opened before the start of my selected date and still open at
> the
> end of my selected range.


SELECT * FROM YourTable WHERE StartDate < Forms![YourForm]![StartDate] AND
EndDate > Forms![YourForm]![EndDateRangeClose]

?

HTH;

Amy


 
Reply With Quote
 
Antavas
Guest
Posts: n/a
 
      14th Jul 2008
Basically my first query allows me to submit a date range for all issue open
dates using the Between [] and [] criteria. The next step I'm trying to
accomplish is take the start date of that range and return all issues that
occurred before that date. These issues must also not have a close date that
falls within that date range.

I hope this clarifies my need. I know what I posted before was a bit
convoluted and thank you for your advice.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wireless issue? DNS issue? MS Update issue? WORLDe Windows XP General 1 14th Jan 2009 11:47 PM
Is this an OFFICE issue or XP issue?? dgs369 Windows XP Help 3 12th Jan 2004 03:14 AM
Is this an OFFICE issue or XP issue?? dgs369 Windows XP General 3 12th Jan 2004 03:14 AM
Is this an OFFICE issue or XP issue?? dgs369 Windows XP Help 1 11th Jan 2004 09:11 PM
Outlook issue, XP issue?? Rebecca Windows XP General 0 17th Nov 2003 12:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:03 PM.