how can the combo choices be counted in report

[reportyemi]

I have a few combo answers such as for example condition of baby and the
various answers in the combo box choices are alive, intensive care,
expired,FSB,MSB ( 5 choices) . So for each baby i choose one of these
conditions as outcome . Now what i want is to report the number of babies
that are alive, in intensive care, FSB and so on. How can i get the report to
count and give me an answer with for example 7 alive babies, 2 in intensive
care and 1 FSB. In otherwords, in my table, one of my columns is this
information and i want to report this among other issues.

also I want to make reports as per months. Patients ar admitted every day
but at the end of a month, i want to be able to generate a report of
specifics information on these patients for a specific month

 

[KC-Mass]

So let's assume your field is named outcome and you want to see the range of
outcomes by the month.

Try something like:

Select * from tblResults
Group on Outcome
Where Month(myDatefield) = 12;


Regards

Kevin

 

[reportyemi]

So let's assume your field is named outcome and you want to see the range of
outcomes by the month.

Try something like:

Select * from tblResults
Group on Outcome
Where Month(myDatefield) = 12;


Regards

Kevin




Sorry Kevin, i dont know where to do what you have advised nor what select*tblresult means. i apologise for my ignorance

 

[KARL DEWEY]

Try this query in design view by selecting YourTable and clicking on the
Greek symbol on the icon bar that looks like an 'M' on its side - ∑ - then in
the grid put these items.
Field: Admission: Format([AdmitDate], "yyyy mm")
Table: YourTable
Total: Group By
Show: Not checked
Sort: Ascending

Field: Admission: Format([AdmitDate], "mmmm yyyy")
Table: YourTable
Total: Group By
Show: Checked
Sort: - blank -

Field: Outcome
Table: YourTable
Total: Group By
Show: Checked
Sort: Ascending

Field: Outcome
Table: YourTable
Total: Count
Show: Checked
Sort: - blank -

Use your table and field names for YourTable, AdmitDate, and Outcome.

 

[reportyemi]

Thank you. It worked. May i indulge further? is it possible to have a combo
box and when i choose an item, it also checks a checkbox.? I have a combo box
with the options single, twin,triplets,quadruplets and others. I also have on
another form 9 really another page) 5 checkboxes. Can my choosing one of my
combo parameter automatically tick the corresponding checkbox further down in
the form?

Try this query in design view by selecting YourTable and clicking on the
Greek symbol on the icon bar that looks like an 'M' on its side - ∑ - then in
the grid put these items.
Field: Admission: Format([AdmitDate], "yyyy mm")
Table: YourTable
Total: Group By
Show: Not checked
Sort: Ascending

Field: Admission: Format([AdmitDate], "mmmm yyyy")
Table: YourTable
Total: Group By
Show: Checked
Sort: - blank -

Field: Outcome
Table: YourTable
Total: Group By
Show: Checked
Sort: Ascending

Field: Outcome
Table: YourTable
Total: Count
Show: Checked
Sort: - blank -

Use your table and field names for YourTable, AdmitDate, and Outcome.

I have a few combo answers such as for example condition of baby and the
various answers in the combo box choices are alive, intensive care,
expired,FSB,MSB ( 5 choices) . So for each baby i choose one of these
conditions as outcome . Now what i want is to report the number of babies
that are alive, in intensive care, FSB and so on. How can i get the report to
count and give me an answer with for example 7 alive babies, 2 in intensive
care and 1 FSB. In otherwords, in my table, one of my columns is this
information and i want to report this among other issues.

also I want to make reports as per months. Patients ar admitted every day
but at the end of a month, i want to be able to generate a report of
specifics information on these patients for a specific month

 

[KARL DEWEY]

Rather than combo and individual check boxes use an option group displaying
check boxes.

Thank you. It worked. May i indulge further? is it possible to have a combo
box and when i choose an item, it also checks a checkbox.? I have a combo box
with the options single, twin,triplets,quadruplets and others. I also have on
another form 9 really another page) 5 checkboxes. Can my choosing one of my
combo parameter automatically tick the corresponding checkbox further down in
the form?

Try this query in design view by selecting YourTable and clicking on the
Greek symbol on the icon bar that looks like an 'M' on its side - ∑ - then in
the grid put these items.
Field: Admission: Format([AdmitDate], "yyyy mm")
Table: YourTable
Total: Group By
Show: Not checked
Sort: Ascending

Field: Admission: Format([AdmitDate], "mmmm yyyy")
Table: YourTable
Total: Group By
Show: Checked
Sort: - blank -

Field: Outcome
Table: YourTable
Total: Group By
Show: Checked
Sort: Ascending

Field: Outcome
Table: YourTable
Total: Count
Show: Checked
Sort: - blank -

Use your table and field names for YourTable, AdmitDate, and Outcome.

I have a few combo answers such as for example condition of baby and the
various answers in the combo box choices are alive, intensive care,
expired,FSB,MSB ( 5 choices) . So for each baby i choose one of these
conditions as outcome . Now what i want is to report the number of babies
that are alive, in intensive care, FSB and so on. How can i get the report to
count and give me an answer with for example 7 alive babies, 2 in intensive
care and 1 FSB. In otherwords, in my table, one of my columns is this
information and i want to report this among other issues.

also I want to make reports as per months. Patients ar admitted every day
but at the end of a month, i want to be able to generate a report of
specifics information on these patients for a specific month

 

[reportyemi]

It looks so much neater to have a form in which i have a combo for the
following
condition - alive,icu,dead,stillbirth
number - single,twins,triplets
delivery - normal,c/s,vacuum

I only wanted to creat the check boxes because i want to have a report where
i can count or sum up these in a month or over a year. So if i can get a
decent alternative, i would rather kepp my combo and have a good reprot
system. It is my frustration that is leading me down tis path but its not
ideal. I simply need help in trying to have one big query and a report that
have all the answers

Rather than combo and individual check boxes use an option group displaying
check boxes.

Thank you. It worked. May i indulge further? is it possible to have a combo
box and when i choose an item, it also checks a checkbox.? I have a combo box
with the options single, twin,triplets,quadruplets and others. I also have on
another form 9 really another page) 5 checkboxes. Can my choosing one of my
combo parameter automatically tick the corresponding checkbox further down in
the form?

Try this query in design view by selecting YourTable and clicking on the
Greek symbol on the icon bar that looks like an 'M' on its side - ∑ - then in
the grid put these items.
Field: Admission: Format([AdmitDate], "yyyy mm")
Table: YourTable
Total: Group By
Show: Not checked
Sort: Ascending

Field: Admission: Format([AdmitDate], "mmmm yyyy")
Table: YourTable
Total: Group By
Show: Checked
Sort: - blank -

Field: Outcome
Table: YourTable
Total: Group By
Show: Checked
Sort: Ascending

Field: Outcome
Table: YourTable
Total: Count
Show: Checked
Sort: - blank -

Use your table and field names for YourTable, AdmitDate, and Outcome.

:

I have a few combo answers such as for example condition of baby and the
various answers in the combo box choices are alive, intensive care,
expired,FSB,MSB ( 5 choices) . So for each baby i choose one of these
conditions as outcome . Now what i want is to report the number of babies
that are alive, in intensive care, FSB and so on. How can i get the report to
count and give me an answer with for example 7 alive babies, 2 in intensive
care and 1 FSB. In otherwords, in my table, one of my columns is this
information and i want to report this among other issues.

also I want to make reports as per months. Patients ar admitted every day
but at the end of a month, i want to be able to generate a report of
specifics information on these patients for a specific month

 

[KARL DEWEY]

You can use the combo for selecting with two columns - ID & Text.
Then use option group to display ID as option choice via check box.

It looks so much neater to have a form in which i have a combo for the
following
condition - alive,icu,dead,stillbirth
number - single,twins,triplets
delivery - normal,c/s,vacuum

I only wanted to creat the check boxes because i want to have a report where
i can count or sum up these in a month or over a year. So if i can get a
decent alternative, i would rather kepp my combo and have a good reprot
system. It is my frustration that is leading me down tis path but its not
ideal. I simply need help in trying to have one big query and a report that
have all the answers

Rather than combo and individual check boxes use an option group displaying
check boxes.

Thank you. It worked. May i indulge further? is it possible to have a combo
box and when i choose an item, it also checks a checkbox.? I have a combo box
with the options single, twin,triplets,quadruplets and others. I also have on
another form 9 really another page) 5 checkboxes. Can my choosing one of my
combo parameter automatically tick the corresponding checkbox further down in
the form?

:

Try this query in design view by selecting YourTable and clicking on the
Greek symbol on the icon bar that looks like an 'M' on its side - ∑ - then in
the grid put these items.
Field: Admission: Format([AdmitDate], "yyyy mm")
Table: YourTable
Total: Group By
Show: Not checked
Sort: Ascending

Field: Admission: Format([AdmitDate], "mmmm yyyy")
Table: YourTable
Total: Group By
Show: Checked
Sort: - blank -

Field: Outcome
Table: YourTable
Total: Group By
Show: Checked
Sort: Ascending

Field: Outcome
Table: YourTable
Total: Count
Show: Checked
Sort: - blank -

Use your table and field names for YourTable, AdmitDate, and Outcome.

:

I have a few combo answers such as for example condition of baby and the
various answers in the combo box choices are alive, intensive care,
expired,FSB,MSB ( 5 choices) . So for each baby i choose one of these
conditions as outcome . Now what i want is to report the number of babies
that are alive, in intensive care, FSB and so on. How can i get the report to
count and give me an answer with for example 7 alive babies, 2 in intensive
care and 1 FSB. In otherwords, in my table, one of my columns is this
information and i want to report this among other issues.

also I want to make reports as per months. Patients ar admitted every day
but at the end of a month, i want to be able to generate a report of
specifics information on these patients for a specific month