automatically fill in fields

G

Guest

Tray
you have to forgive me. I'm really new at this and I dont think automatically filling in my field is what I need. Let me explain in further detail. What I want in the end is a report that will look like this example

Name Suicide Redbook Fire Safety CMPR
Johnny Mays 01/05/04 3/25/04
Mary Acquilla 4/10/04 3/25/04 01/12/04

My problem is all the trainings are under a combo box and I can't figure out how to get the Items listed in my combo box as coulum headings in my report. These and more are in my combo box, but I dont need them all just the mandatory ones like; Sucide, Redbook, Fire Safety, CMPR etc . Also, If they havent taken that course yet it would need to show on the report. How you know they took the course is by the date. Would you be able to help me with this. I would not even need this one subform if I could just make my report.
Thanks Jen
 
M

Michel Walsh

Hi,



Probably a question of vocabulary, but a report should be based on a
TABLE (or QUERY), not on a form. If your table is like

Name CourseName DateTaken ' fields name
Johnny Mays Redbook 01/05/2004
Johnny Mays Fire Safety 3/25/2004
Mary Acquilla Suicide 4/10/2004
Mary Acquilla CMPR 01/12/2004





then, you may decide to first build a CROSS TAB query. Use the help of the
Query Wizard to produce it, you will GROUP on Name, you will PIVOT on
CourseName, and you will aggregate with MAX over the DateTaken. Edit the
query, be sure to have the query property sheet visible, and under the
Column Headers property, specify "Redbook", "Fire Safety", "Suicide",.
"CMPR". Save the query. Take a look at the data view, should be exactly
as you want! If you want to add one more "course name", edit the Column
Headers appropriately.


Build the report based on the crosstab query just saved.



Hoping it may help,
Vanderghast, Access MVP



Angel said:
Tray
you have to forgive me. I'm really new at this and I dont think
automatically filling in my field is what I need. Let me explain in further
detail. What I want in the end is a report that will look like this example
Name Suicide Redbook Fire Safety CMPR
Johnny Mays 01/05/04 3/25/04
Mary Acquilla 4/10/04 3/25/04 01/12/04

My problem is all the trainings are under a combo box and I can't figure
out how to get the Items listed in my combo box as coulum headings in my
report. These and more are in my combo box, but I dont need them all just
the mandatory ones like; Sucide, Redbook, Fire Safety, CMPR etc . Also, If
they havent taken that course yet it would need to show on the report. How
you know they took the course is by the date. Would you be able to help me
with this. I would not even need this one subform if I could just make my
report.
 
G

Guest

Miche
Thank you that solved it. In my subform I enter data but I would like the blank record to be at the top. I have to keep scrolling to the bottom and its a pain. Can this be done
Thank
Jen
 
M

Michel Walsh

Hi,


It may be easier to use the navigational button >* ( a triangle
followed by a star), it jumps immediately to a new record, avoiding the
painful scrolling portion of the job.

A possible work around to have the first record as the "new record", but
be warned it requires some work, is to use two subforms. The first one is in
a single record view, in an append data only mode, the second subform is for
the existing data, a continuous view. With proper care, no border delimiting
the subform, with the first one properly positioned on top of the second...
see... see...? is it worth the effort?



Hoping it may help,
Vanderghast, Access MVP


angel said:
Michel
Thank you that solved it. In my subform I enter data but I would like the
blank record to be at the top. I have to keep scrolling to the bottom and
its a pain. Can this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top