User Profile

Collapse

Profile Sidebar

Collapse
christian85
christian85
Last Activity: Aug 23 '10, 11:53 AM
Joined: Mar 24 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • christian85
    replied to Crosstab subqueries
    in Access
    Thanks for your reply Zepphead80.

    However, I tried grouping them in the outer query (you cant do this in the inner query because of the aliases). This still gives the following error message: "Database engine does not recognize q.id as a valid field name or expression"

    This is the adjusted query:
    Code:
    PARAMETERS MemberID Short;
TRANSFORM Sum(t1.Score) AS SumOfScore
SELECT t1.questionid, t1.Assigned,
    ...
    See more | Go to post

      Leave a comment:

    • christian85
      started a topic Crosstab subqueries
      in Access

      Crosstab subqueries

      Hi everyone,

      I can't seem to get this query right. It seems that crosstab queries don't support subqueries or is it? How should i rewrite this? It's too nasty to expand the whole query in four statements and union them together...

      Code:
      SELECT t1.companyname AS Supplier, t1.questionid, t1.Assigned, t1.Question, t1.Weight, c.CategoryName AS Category, t1.Score
FROM (

SELECT s2.companyname, q.id as questionid,
      ...
      See more | Go to post
      • christian85
        started a topic Records as columns in updatable table
        in Access

        Records as columns in updatable table

        Hi,

        I have three tables: question, teammember and assignedQuestio ns

        A question can be assigned to multiple teammembers, this will be recorded in the assignedQuestio ns table.

        What I want now is a list of TeamMembers as columns in a datasheet with the questionnumbers on every row and checkboxes as a value for every cell so that I can assign a question to every teammember. Like this:

        _____Member1__M ember2__Member3...
        See more | Go to post
        No activity results to display
        Show More
        Working...