two sets of data in one query

[BlackIce]

I want to query one table and get back two simple sets of data with one
query. I have a table with date start, date ended,
scheduled/unscheduled. I want to be able to get all of the dates
within a particular month and separate them out but scheduled or
unscheduled. so the result of the query would look like

Scheduled Unscheduled
June 5 7
July 2 1
August 8 15
I already figured out how to separate things out by 1 month its just
the sorting by scheduled/unscheduled that is the problem and putting
them in two different fields with all months

so my output so far look like

june 25

Thanks

[ManningFan]

Sounds like you're going to want to use a sum query. Group by
month(date), count(scheduled = yes), count(scheduled = no).

What happens if start date and end date don't fall in the same month?
BlackIce wrote:

I want to query one table and get back two simple sets of data with one
query. I have a table with date start, date ended,
scheduled/unscheduled. I want to be able to get all of the dates
within a particular month and separate them out but scheduled or
unscheduled. so the result of the query would look like

Scheduled Unscheduled
June 5 7
July 2 1
August 8 15
I already figured out how to separate things out by 1 month its just
the sorting by scheduled/unscheduled that is the problem and putting
them in two different fields with all months

so my output so far look like

june 25

Thanks

[BlackIce]

Could you give me some more detail on how to setup the query?
Thanks

[ManningFan]

Hmmm...

Build a new query, bring in your table, and click the Sum button (it
looks like an "E", usually not far from the red "exclamation point"
button).

You'll have to write a new field that will look something like,
MthField: month(StartDate) and on the 3rd line down click the dropdown
and choose "Group By" (it may default to it).

Set up another field that looks something like, Sel: iif(Selected =
yes, 1, 0) and on the 3rd line down click the dropdown and choose
"Sum".

Set up another field that looks something like, UnSel: iif(Selected =
no, 1, 0) and on the 3rd line down click the dropdown and choose "Sum".

This should group by month and total up all the selected and unselected
records.

This code isn't exact, it will require a little tweaking, but it's 90%
done. As a rule I never do 100% of the work for someone unless I'm
getting paid for it.

BlackIce wrote:

Could you give me some more detail on how to setup the query?
Thanks

[BlackIce]

I appologise, I must have mistated my question, but there is a field in
the DB that has text that will be "scheduled" or "unscheduled" i solved
the problem though so thanks for all your help.

SELECT
Count(IIf([RecordedDownTime.Scheduled_Unscheduled]="Scheduled",0)) AS
Sched,
Count(IIf([RecordedDownTime.Scheduled_Unscheduled]="Unscheduled",0)) AS
Unsched
FROM RecordedDownTime
WHERE (((Month([Start_Date]))=6));

[Larry Linson]

Don't be turned off by someone who won't fully answer a question in the
newsgroup. There are many who give detailed, complete answers, if the poster
provides sufficient detail.

Larry Linson
Microsoft Access MVP

"BlackIce" <Bl*********@gmail.com> wrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...

I appologise, I must have mistated my question, but there is a field in
the DB that has text that will be "scheduled" or "unscheduled" i solved
the problem though so thanks for all your help.

SELECT
Count(IIf([RecordedDownTime.Scheduled_Unscheduled]="Scheduled",0)) AS
Sched,
Count(IIf([RecordedDownTime.Scheduled_Unscheduled]="Unscheduled",0)) AS
Unsched
FROM RecordedDownTime
WHERE (((Month([Start_Date]))=6));