New To Access.
I have a Data Table/Chart in Excel which I would like to incorporate into Access07. I would like the final Access Report to allow me to view the chart as in the picture for one specific record (patient) at a time combined with data from additional tables relating to this specific patient.
I am stuck trying to figure out how to arrange the Access Table in a logical way so that the information can convert to a Pivot Chart and viewed on an Access Report. Any advice on how to set up the access table would be greatly appreciated.
You can see what I am looking at in Excel on the Attachment.
Thanks in advance for your assistance.
I have a Data Table/Chart in Excel which I would like to incorporate into Access07. I would like the final Access Report to allow me to view the chart as in the picture for one specific record (patient) at a time combined with data from additional tables relating to this specific patient.
I am stuck trying to figure out how to arrange the Access Table in a logical way so that the information can convert to a Pivot Chart and viewed on an Access Report. Any advice on how to set up the access table would be greatly appreciated.
You can see what I am looking at in Excel on the Attachment.
Thanks in advance for your assistance.
