[AccessD] crosstab query

Jon Albright jon.albright at hawaii.rr.com
Wed Jul 2 19:07:15 CDT 2014


I had pondered if it could be done that way but I wasn't sure if I could get
the crosstab to work with text values.  I find that if set to count it will
tabulate text values.  So, theoretically if I created 3 crosstab queries
these would be added to a standard query in the same manner as you add
multiple tables?

Jon Albright

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Tuesday, July 01, 2014 6:37 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] crosstab query

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
--
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