User Profile

Collapse

Profile Sidebar

Collapse
Tererai
Tererai
Last Activity: Oct 12 '07, 07:03 AM
Joined: Jan 18 '07
Location: Harare
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tererai
    started a topic asp and asp.net
    in ASP Classic

    asp and asp.net

    i am using wndows 2003 server and asp.net is enabled.And my main questiopn is can I use ASP on the asp.net
    See more | Go to post
    • Tererai
      replied to Criteria for a crosstab query
      in Access
      I finally figured out where i went wrong.Now have the query up and running and i have pasted the SQL format below.

      Code:
      PARAMETERS [month and year] Text ( 255 );
TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
FROM qryJoining
GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
      ...
      See more | Go to post

        Leave a comment:

      • Tererai
        replied to Criteria for a crosstab query
        in Access
        Code:
        PARAMETERS [month and year] Text ( 255 );
TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
FROM qryJoining
GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
PIVOT qryJoining.Item_ID;
        See more | Go to post

          Leave a comment:

        • Tererai
          replied to Criteria for a crosstab query
          in Access
          Hi

          Thanks for the tip. It worked.

          Tererai
          See more | Go to post

            Leave a comment:

          • Tererai
            started a topic Criteria for a crosstab query
            in Access

            Criteria for a crosstab query

            Hi guys? I am new to this community, i'm very pleased to join you.

            For the past 2 weeks i have been trying to specify criteria in a crosstab query but i get a fun message which says"Microsoft Jet Database does not recognize whatever criteria i would have specified as valid field name or expression."

            I am stuck and don't know what to do next.
            See more | Go to post
            No activity results to display
            Show More
            Working...