If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Grouping data on a form
I’m trying to create a form that is grouped by individual names with the data
pertaining to that name listed below it. I know this can be done on a report but, I just can figure out how to do this on a form. Example; Name 1 Med1 Generic1 Dose 1 Med2 Generic2 Dose 2 Name 2 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 Name 3 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 |
#2
|
|||
|
|||
Grouping data on a form
On Thu, 1 Oct 2009 16:34:22 -0700, Harold
wrote: Perhaps you can create a subform with names, and a subsubform with Meds. Both would be in datasheet view. -Tom. Microsoft Access MVP I’m trying to create a form that is grouped by individual names with the data pertaining to that name listed below it. I know this can be done on a report but, I just can figure out how to do this on a form. Example; Name 1 Med1 Generic1 Dose 1 Med2 Generic2 Dose 2 Name 2 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 Name 3 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 |
#3
|
|||
|
|||
Grouping data on a form
Thanks Tom,
I could make it work but, it is not really what im looking for. I will have to play with it a little more but, I would like to do it as a continuous form. "Tom van Stiphout" wrote: On Thu, 1 Oct 2009 16:34:22 -0700, Harold wrote: Perhaps you can create a subform with names, and a subsubform with Meds. Both would be in datasheet view. -Tom. Microsoft Access MVP I’m trying to create a form that is grouped by individual names with the data pertaining to that name listed below it. I know this can be done on a report but, I just can figure out how to do this on a form. Example; Name 1 Med1 Generic1 Dose 1 Med2 Generic2 Dose 2 Name 2 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 Name 3 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 |
#4
|
|||
|
|||
Grouping data on a form
On Fri, 2 Oct 2009 00:03:01 -0700, Harold
wrote: Sorry, continuous forms cannot have subforms. I am assuming someone could have many meds. -Tom. Microsoft Access MVP Thanks Tom, I could make it work but, it is not really what im looking for. I will have to play with it a little more but, I would like to do it as a continuous form. "Tom van Stiphout" wrote: On Thu, 1 Oct 2009 16:34:22 -0700, Harold wrote: Perhaps you can create a subform with names, and a subsubform with Meds. Both would be in datasheet view. -Tom. Microsoft Access MVP I’m trying to create a form that is grouped by individual names with the data pertaining to that name listed below it. I know this can be done on a report but, I just can figure out how to do this on a form. Example; Name 1 Med1 Generic1 Dose 1 Med2 Generic2 Dose 2 Name 2 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 Name 3 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 |
#5
|
|||
|
|||
Grouping data on a form
Yes one person could have anywhere from one to a hundred meds. I was hoping
to not have any sub forms and group by names on the form. In the same way you can do grouping on a report. "Tom van Stiphout" wrote: On Fri, 2 Oct 2009 00:03:01 -0700, Harold wrote: Sorry, continuous forms cannot have subforms. I am assuming someone could have many meds. -Tom. Microsoft Access MVP Thanks Tom, I could make it work but, it is not really what im looking for. I will have to play with it a little more but, I would like to do it as a continuous form. "Tom van Stiphout" wrote: On Thu, 1 Oct 2009 16:34:22 -0700, Harold wrote: Perhaps you can create a subform with names, and a subsubform with Meds. Both would be in datasheet view. -Tom. Microsoft Access MVP I’m trying to create a form that is grouped by individual names with the data pertaining to that name listed below it. I know this can be done on a report but, I just can figure out how to do this on a form. Example; Name 1 Med1 Generic1 Dose 1 Med2 Generic2 Dose 2 Name 2 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 Name 3 Med 1 Generic1 Dose 1 Med 2 Generic2 Dose 2 |
#6
|
|||
|
|||
Grouping data on a form
On Fri, 2 Oct 2009 11:49:10 -0700, Harold
wrote: Yes one person could have anywhere from one to a hundred meds. I was hoping to not have any sub forms and group by names on the form. In the same way you can do grouping on a report. As far as I know, you cannot. You *certainly* could not do so and have the data updateable, except by drastic denormalization. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|