Dan Waters
df.waters at outlook.com
Tue Jul 1 09:08:52 CDT 2014
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