Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I need a crosstab type form (access 2002 SP3)

    I have an attendance role that I wish to present in a crosstab type form with names in left col. and names of functions attended as row headings. Just as paper attendance roles look. The number of Functions attended can vary from none to any number. It is based on tblContacts & tblAttendance, linked to tblContacts through ID & tblFunctions linked to tblAttendance through FunctionID.
    If I make a pivot table form, then, if the number or names of the Functions has changed, the number or names of columns won
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: I need a crosstab type form (access 2002 SP3)

    Instead of creating a pivot table form, you could create a crosstab query and a datasheet form based on the crosstab query. (I usually avoid datasheet forms, but this might be a situation to use them in, for a datasheet form will dynamically adjust the number and names of the columns.)

    If the list of functions is fixed, you could enter the list of functions in the Column Headings property of the crosstab query. This will fix the name and number of the columns. You could then create a continuous form based on the crosstab query (you can't use a continuous form is the columns vary in name and number.)

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I need a crosstab type form (access 2002 SP3)

    Thanks Hans. I tried the datasheet. However, with the form that I build in code each time, I can have a double click event to mark the person as having attended or not. (adds/ removes an asterisk in the control). With the Datasheet that can
    Regards,
    Peter

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: I need a crosstab type form (access 2002 SP3)

    Unless you can use a crosstab query with fixed column headings, I think you're stuck with what you have now.

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I need a crosstab type form (access 2002 SP3)

    Thanks Hans.
    I don't feel so bad if the master himself can't see a solution either. If something does occur to you, please let me know.
    Regards,
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •