Results 1 to 2 of 2
  1. #1
    leahcim_32 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    1

    concat problem

    ***i have this query....it has a concatenated field ---rs number



    SELECT dbo_MAIN.DATE, dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[OUTLET NO], dbo_MAIN.NAME2, dbo_MAIN.RATE, dbo_MAIN.REMARKS, _
    dbo_MAIN.[CUSTOMER TYPE], ConcatRelated("[RS NUMBER]","[waybill list query]",_
    "[OUTLET NO] & [VISIT FORM NO]= """ & [OUTLET NO] & [VISIT FORM NO] & """") AS [RS NUMBER]
    FROM dbo_MAIN
    GROUP BY dbo_MAIN.DATE, dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[OUTLET NO], dbo_MAIN.NAME2, dbo_MAIN.RATE, dbo_MAIN.REMARKS, dbo_MAIN.[CUSTOMER TYPE]
    HAVING (((dbo_MAIN.DATE) Between [FORMS]![RSWAYBILL]![BEGINDATE] And [FORMS]![RSWAYBILL]![ENDDATE]));

    **the first query looks to this query to concatenate rs numbers....

    SELECT dbo_MAIN.[OUTLET NO], dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[RS NUMBER]
    FROM dbo_MAIN
    GROUP BY dbo_MAIN.[OUTLET NO], dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[RS NUMBER], dbo_MAIN.DATE
    HAVING (((dbo_MAIN.DATE) Between [FORMS]![RSWAYBILL]![BEGINDATE] And [FORMS]![RSWAYBILL]![ENDDATE]));

    ***and this is my problem everytime i run the first query.....

    error 3061: too few parameters. expected 2


    help on this pls....
    tnx

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    First query should read

    Code:
     
    SELECT [DATE] Ad fldDate, 
               [VISIT FORM NO], 
               [OUTLET NO], 
               [NAME2], 
               [RATE], 
               [REMARKS],
               [CUSTOMER TYPE], 
               ConcatRelated([RS NUMBER],
                                   [waybill list query],
                                   [OUTLET NO] & [VISIT FORM NO]= "'" & 
                                   [OUTLET NO] & [VISIT FORM NO] & "'") 
                              AS [RS NUMBER]
    FROM dbo_MAIN
    GROUP BY [DATE], 
                  [VISIT FORM NO], 
                  [OUTLET NO], 
                  [NAME2], 
                  [RATE],
                  [REMARKS]
                  [CUSTOMER TYPE]
    WHERE [DATE]  Between #  & [FORMS]![RSWAYBILL]![BEGINDATE] & # 
    And # & [FORMS]![RSWAYBILL]![ENDDATE] # & ";"

    For a start do not use date as a field name this is a reserved word in Access. Secondly I do not know what you are trying to do when you say concatenate, which fields are you trying to concat?

    Also you needed #'s around your date type filter expressions.

    The error message you are getting usually means that the name of two fields in your sql statement cannot be found in the actual table/query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. query problem i have a problem wi
    By maxx3 in forum Queries
    Replies: 0
    Last Post: 06-29-2009, 02:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums