Jon Albright
jon.albright at hawaii.rr.com
Tue Jul 1 11:27:00 CDT 2014
No, not using 2010 any longer, upgraded to 2013 several months ago. Do you suppose it will work with 2013??? Jon Albright Iniki Enterprises Honolulu, Hawaii (808) 677-7800 x116 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, July 01, 2014 4:09 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] crosstab query Hi Jon, If you are using Office 2010, you can download an Excel add-in called Power Pivot (PP). PP will connect to any database, and can be used to create any query you want which can then be displayed as a report or chart. I haven't started using it yet but I'm sure you can save whatever queries/charts/reports you create. Good Luck! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jon Albright Sent: Monday, June 30, 2014 0:04 AM To: accessD at databaseadvisors.com Subject: [AccessD] crosstab query Is there a way to use a crosstab query with text only fields? I need to print a report that lists record data horizontally similar to what a crosstab query does. The data is derived from an ipad app for the collection of diabetes recordkeeping (mine). The app produces a report in excel format and I import it into a database table. I am able to group the data by various fields in the table but am unable to create a report that will display the data in a horizontal format. The fields that are in the table are Date, Time (self-explanatory), Category (displays either morning, noon or evening), Type (displays either medication, glucose or food), Value (corresponds to Type field and displays medication amount, glucose reading or amount of carbohydrates consumed), Item (corresponds to Type and displays medication name, method of glucose measurement or Carbs), and Note (description of what this record is displaying). My need is to display the record data for an entire day (there are several records for each day, upwards of a dozen) so that my doctor will see the previously listed fields on one line for an entire day with subsequent days in the same format instead of one line per record. Can a crosstab query do this or is there another way? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com