[AccessD] crosstab query

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



More information about the AccessD mailing list