REPORT FROM QUERY WITH COMBO BOX

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im trying to make a report from a query. I have a combo box that list several training example Fire Safety, Suicide, Redbook. I also have a date field. I want my report to have each one of these trainings as a title. I would like them in a column like this example below. Can this be done? Any help appreciate

Staff Name Fire Safety Suicide Redboo
2/12/02 1/14/04 6/3/0

Angel 82
 
Your example doesn't describe your actual data. It is also difficult to
visualize what you expect for results. Try providing a sample of your actual
data.

--
Duane Hookom
MS Access MVP


ANGEL 82 said:
Im trying to make a report from a query. I have a combo box that list
Click to expand...
several training example Fire Safety, Suicide, Redbook. I also have a date
field. I want my report to have each one of these trainings as a title. I
would like them in a column like this example below. Can this be done? Any
help appreciated
 
the items listed in my combo box i want as coloumn titles in my report. I dont know how to get the data in the

----- ANGEL 82 wrote: ----

Im trying to make a report from a query. I have a combo box that list several training example Fire Safety, Suicide, Redbook. I also have a date field. I want my report to have each one of these trainings as a title. I would like them in a column like this example below. Can this be done? Any help appreciate

Staff Name Fire Safety Suicide Redboo
2/12/02 1/14/04 6/3/0

Angel 82
 
Duane what I am looking for in my report is the staffs name with all the training and dates of training he has had on the same row. I don't want his name listed 6 different row

----- ANGEL 82 wrote: ----

Im trying to make a report from a query. I have a combo box that list several training example Fire Safety, Suicide, Redbook. I also have a date field. I want my report to have each one of these trainings as a title. I would like them in a column like this example below. Can this be done? Any help appreciate

Staff Name Fire Safety Suicide Redboo
2/12/02 1/14/04 6/3/0

Angel 82
 
You didn't provide any sample actual data, field or table names, or other
description of your data. Does a staff person take the same training more
than once? How would this be shown? There are several crosstab report
samples in the crosstab download at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
Duane Hookom
MS Access MVP


angel82 said:
Duane what I am looking for in my report is the staffs name with all the
Click to expand...
training and dates of training he has had on the same row. I don't want his
name listed 6 different rows
----- ANGEL 82 wrote: -----

Im trying to make a report from a query. I have a combo box that
Click to expand...
list several training example Fire Safety, Suicide, Redbook. I also have a
date field. I want my report to have each one of these trainings as a title.
I would like them in a column like this example below. Can this be done?
Any help appreciated
 
Back
Top