Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Location
    Latvia
    Posts
    13

    Question Unanswered: How can I do it?!

    i have qwery:

    SELECT Darijums.Prec_KN_kods, Round(Sum(Darijums!Cena)*0.662,0) AS Summa, Round(Sum(Darijums!Masa),0) AS Masa, Sum(Darijums!Daudzums) AS Daudzums, Darijums.Nos_v_kods, Darijums.Izc_v_kods, Darijums.Dar_kods
    FROM Darijums
    WHERE (((Darijums.Oper_num)=3) AND ((Darijums.[Ienak/Izej])=Yes))
    GROUP BY Darijums.Prec_KN_kods, Darijums.Nos_v_kods, Darijums.Izc_v_kods, Darijums.Dar_kods
    ORDER BY Darijums.Prec_KN_kods;


    how can i do this: IF "Darijums.Prec_KN_kods" = 84733010 and 84733090 then in field "Darijums.Daudzums" don`t display (in REPORT form) values (just emtpy fields), but if in "Darijums.Prec_KN_kods" are other numbers then display value in "Darijums.Daudzums"

    tnx
    Last edited by qce; 08-09-04 at 10:23.

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    I think you put your VB code into the "Detail_Print" section of the report. Something like:
    IF (Darijums.Prec_KN_kods = 84733010) and (Darijums.Prec_KN_kods = 84733090) then
    Me.(yourFieldName).Visible = false
    else
    Me.(yourFieldName).Visible = true
    end if

  3. #3
    Join Date
    Jul 2004
    Location
    Latvia
    Posts
    13
    Run-time error '424':
    Object requiered

    what that mean?!

Posting Permissions

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