User Profile

Collapse

Profile Sidebar

Collapse
iChappy
iChappy
Last Activity: Mar 14 '08, 01:19 PM
Joined: Mar 13 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • iChappy
    replied to Form Based Query
    in Access
    All is working now. Thank you for your help!...
    See more | Go to post

      Leave a comment:

    • iChappy
      replied to Form Based Query
      in Access
      Thank You!!!
      It is in the WHERE criteria of the below query that references to the Fiscal Week field in the form. ([Forms]![Fiscal Week Form]![Fiscal Week]
      Code:
      SELECT [Driver QOS Sum Report Detail Query].Driver,
       Avg([Driver QOS Sum Report Detail Query].[Blended QOS]) AS [AvgOfBlended QOS],
       Avg([Driver QOS Sum Report Detail Query].[Total QOS]) AS [AvgOfTotal QOS],
       Avg([Driver QOS Sum Report Detail
      ...
      See more | Go to post

        Leave a comment:

      • iChappy
        replied to Form Based Query
        in Access
        Yes, good assumption:
        Forms![Fiscal Week Form]![Fiscal Week]!

        I am new to the coding side of it... would you please provide the full code?...
        See more | Go to post

          Leave a comment:

        • iChappy
          started a topic Form Based Query
          in Access

          Form Based Query

          I have a query based off of two fields in an Access form:

          Fiscal Week (user manual inputs #) & Fiscal Year (combo box defaulted to current year however may select other years)

          The query is a where query and the criteria is based on the values of the above listed form fields.

          Here is my delima: If a user types 05 into the Fiscal Week field on the form then the query runs properly; however if a 5 is...
          See more | Go to post
          No activity results to display
          Show More
          Working...