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