[AccessD] crosstab query

Gary Kjos garykjos at gmail.com
Tue Jul 1 11:37:28 CDT 2014


What I have done for this type of thing before is to create several cross
tabs - one for each field I am interested in possibly - and then use those
crosstab queries as input to another query that joins those crosstabs and
can then display the results of the conbination of the two or more
crosstabs. I have done it with a half doze or more sub/crosstab queries.
Things can get wonky over time as new values may be introduced that present
new columns in the crosstab, but it works well for the initial data you are
using at the time you develop it and will keep working well as long as your
data entry is consistent.

GK


On Tue, Jul 1, 2014 at 11:27 AM, Jon Albright <jon.albright at hawaii.rr.com>
wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com


More information about the AccessD mailing list