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

    Question Unanswered: Need help with REPORT! [Updeted]

    I have table with 2 collums and 650 rows. In field "stuff" i have numbers (codes) like 8444212 etc. and in field "price" 34$ etc. how can i do this thing:

    when i make REPORT form where in field "stuf" numbers are 8444212 the don`t show in field "price" value, but if in filed "stuf" is onther number then it shows field "price" value.

    can someone help me with than problem! i`m newbee in MS access
    Attached Thumbnails Attached Thumbnails 1.JPG  
    Last edited by qce; 08-09-04 at 09:22.

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    This is incomprehensible, if you want help, please upload a zipped database.

  3. #3
    Join Date
    Jul 2004
    Location
    Latvia
    Posts
    13
    Ok i uploud file.
    In report form - INBOUND in field "D" are numbers, but in field "A" are codes.
    for CODE 84733010 i need that in ield "D" dont show value.
    mabey in qwery can make criteria with IF!? but how do it?!

    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;
    Attached Files Attached Files
    Last edited by qce; 08-09-04 at 10:15.

Posting Permissions

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