Results 1 to 7 of 7

Thread: Report

  1. #1
    Join Date
    Oct 2007
    Posts
    11

    Unanswered: Report

    Hi,

    I need a small help wrt reports in MS Access.

    I have a report linked to a query which details employee's address and outstanding stock options. When I try to preview the report it asks me to enter a parameter value for 'Surname'. There was one instance where the Forename and Surname are obtained from the query which is working fine.

    I have checked the query and the design of the report, and there is no where have I created another text box for printing Surname.

    I have tried giving some long junk name to check if it is being printed anywhere on the report, but it doesn't seem to be appearing on the report.

    Could there be any other reason?
    Any help would be greatly appreciated.

    Looking forward to a response !

    Kind regards,
    Sowmya

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Open the quer and change o SQL view. Copy what's in there and post it back here
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    11
    Here u go..

    Thanks,
    Sowmya


    SELECT tblOptions.TRANSACTIONID, tblOptions.GRANT_DATE, tblOptions.OPTION_PRICE, tblOptions.NO_OPTIONS AS Granted, IIf([NO_LAPSED] Is Null,0,[NO_LAPSED]) AS Lapsedtodate, IIf([Exercised_todate] Is Null,0,[Exercised_todate]) AS Exercisedtodate, [Granted]-[Lapsedtodate]-[Exercisedtodate] AS Optionos, tblOptions.NO_LAPSED, tblOptions.DATE_LAPSED, tblOptions.DATE_LAPSED_UPDATE, tblOptions.[NO_CPTE registrar], tblParticipants.[Emp No], tblParticipants.NOM, tblParticipants.PRENOM, IIf(tblParticipants!Leaverid Is Null,DateAdd("yyyy",10,[GRANT_DATE]),IIf(tblParticipants!Leaverid=5 Or tblParticipants!Leaverid=7,[Leavedate],DateAdd("d",1,DateAdd("m",3,[leavedate])))) AS Expires, IIf([employee number] Is Null,[Adr1],[address line1]) AS Address11, IIf([employee number] Is Null,[Adr2],[address line2]) AS Address22, IIf([employee number] Is Null,[Adr3],[address line3]) AS Address33, IIf([employee number] Is Null,[Adr4],[address line4]) AS Address44, IIf([employee number] Is Null,[Postcode],[post code]) AS Postcodee, IIf(tblParticipants!leaverid Is Not Null,DateAdd("m",3,[leavedate]),DateAdd("yyyy",10,[Grant_date])) AS Last_date_to_exercise, IIf([96scr]!Leavedate Is Null,tblParticipants!Leavedate,[96scr]!Leavedate) AS leavedate, DateAdd("yyyy",3,[Grant_date]) AS Vesting_date, tblOptions.Plan_ref, Leaverreasons.leavereason, tblParticipants!Leaverid AS leaver_status
    FROM ((((tblParticipants LEFT JOIN (Leaverreasons RIGHT JOIN 96scr ON Leaverreasons.leavereason = [96scr].leavereason) ON tblParticipants.[Emp No] = [96scr].empno) LEFT JOIN Addresses ON tblParticipants.[Emp No] = Addresses.[employee number]) LEFT JOIN tblOptions ON tblParticipants.NO_CPTE = tblOptions.[NO_CPTE registrar]) LEFT JOIN Q_sum_exercises ON tblOptions.TRANSACTIONID = Q_sum_exercises.TRANSACTIONID) LEFT JOIN [Leaver codes] ON tblParticipants.LeaverId = [Leaver codes].leaverid
    WHERE (((tblOptions.[NO_CPTE registrar])=[Forms]![frm_Participants]![NO_CPTE]));

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    check for any sorting, grouping or filters in your report that reference 'surname'

  5. #5
    Join Date
    Oct 2007
    Posts
    11
    I have had a look at the report design. It looks like it has all default settings in the properties. There is no specific sorting, grouping or filters for 'Surname'.

  6. #6
    Join Date
    Feb 2007
    Posts
    348
    check to control source of your field for surname in your report. I'll bet there is a typo in there.
    It's asking you where it should get the info for the fieldname surname. So if you don;t get that when you open the query, it's in the report.

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are any of the sources (tables / queries) using the surname field?
    George
    Home | Blog

Posting Permissions

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