Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cross tab query in subform possible? (97)

    cross tab query in subform possible?
    A cross tab query has a nice X & Y axis look to it & I

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cross tab query in subform possible? (97)

    Hi Arage

    Cross-tab queries take data in a query and use the values in one column to create a column for each value. This effectively spins the table around.

    As far as I know, you cannot enter values into a Cross-tab query (because of the way it calculates the 'values', they are aggregates of individual fields).

    The way around this would be to create your table to 'look' like the structure you want to enter into and base your form on this table. Then at a later stage, use some make table and append queries to turn the column names in your table into values in a new table (or if you didn't want to do this you could just leave the table how it was).

    Hope that this helps

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: cross tab query in subform possible? (97)

    Crosstabs are NOT updateable, period. There are datagrid controls that give you a similar effect, but they're tricky to use and have licensing issues. I'd avoid getting too fancy with "look" and stick to getting the job done. Using a two-stage process with an intermediate table, as Jayden suggests, is a possibility, but it requires quite a bit of extra work to get the data into and out of the underlying active tables and it means that any multi-user data doesn't get updated immediately.
    Charlotte

Posting Permissions

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